I tried the following question in setup, but didn't get an answer. I think
not being able to install sqlserver 2000 is a serious problem. I'd
appreciate any help.
thanks.
dennist685
When I try to install sql server 2000 I get the following message.
Microsoft sql server 2000 enterprise edition server component is not
supported on this operating system. Only client components will be available
for installation.
I have xp pro.
I have never installed sql server 2000 before.
If client components are sufficient, how do I configure the security as
simple as possible. For now, just so I can sign in with all rights, with as
little typing as possible.
I went this far before cancelling. I clicked setup(I have the msdn DVD
version). After clicking next a few times it gave me the choice of client
tools only or connectivity only. The option button for server and client
tools was greyed out.
I have adsl and an ethernet card for the adsl, but I am not connected to any
sqlserver 2000.
Please help.
dennist685
Hi,
The server components of the Enterprise Edition could not be installed on xp.
You should use the Developer Edition if you want to install all components
on xp.
If you do not have any server component available, client components only
will not provide the ability to create databases/tablesâ?¦.
Lionel
my answer
Thanks Lionel. I chose the developer edition, server and client tools.
However when I get to services accounts I accepted the default - use a domain
user account. It had the username I use for logon to windows - dennist685.
the domain name was my first name in Caps. I tried several passwords, but got
the following error message:
The logon account cannot be validated for the sql server service. Verify
that the user name and password entered are correct. The logon attempt
failed.
Any ideas?
dennist685"dennist685" <dennist685@.discussions.microsoft.com> wrote in message
news:9ABFFC87-5999-4FDE-83D8-84E1CC3BF0E7@.microsoft.com...
>I tried the following question in setup, but didn't get an answer. I think
> not being able to install sqlserver 2000 is a serious problem. I'd
> appreciate any help.
> thanks.
> dennist685
> When I try to install sql server 2000 I get the following message.
> Microsoft sql server 2000 enterprise edition server component is not
> supported on this operating system. Only client components will be
> available
> for installation.
> I have xp pro.
> I have never installed sql server 2000 before.
> If client components are sufficient, how do I configure the security as
> simple as possible. For now, just so I can sign in with all rights, with
> as
> little typing as possible.
> I went this far before cancelling. I clicked setup(I have the msdn DVD
> version). After clicking next a few times it gave me the choice of client
> tools only or connectivity only. The option button for server and client
> tools was greyed out.
> I have adsl and an ethernet card for the adsl, but I am not connected to
> any
> sqlserver 2000.
> Please help.
> dennist685
> Hi,
> The server components of the Enterprise Edition could not be installed on
> xp.
> You should use the Developer Edition if you want to install all components
> on xp.
> If you do not have any server component available, client components only
> will not provide the ability to create databases/tables..
> Lionel
> my answer
> Thanks Lionel. I chose the developer edition, server and client tools.
> However when I get to services accounts I accepted the default - use a
> domain
> user account. It had the username I use for logon to windows -
> dennist685.
> the domain name was my first name in Caps. I tried several passwords, but
> got
> the following error message:
> The logon account cannot be validated for the sql server service. Verify
> that the user name and password entered are correct. The logon attempt
> failed.
> Any ideas?
> dennist685
On xp you can install only the "desktop" or "developer" edition. Find it in
you msdn cd collection.|||"Giuseppe Battaglia" <beppeb_datogliere@.tiscali.it> wrote in message
news:QSesd.26134$C94.25844@.tornado.fastwebnet.it...
>> Thanks Lionel. I chose the developer edition, server and client tools.
>> However when I get to services accounts I accepted the default - use a
>> domain
>> user account. It had the username I use for logon to windows -
>> dennist685.
>> the domain name was my first name in Caps. I tried several passwords, but
>> got
>> the following error message:
>> The logon account cannot be validated for the sql server service. Verify
>> that the user name and password entered are correct. The logon attempt
>> failed.
>> Any ideas?
>> dennist685
> On xp you can install only the "desktop" or "developer" edition. Find it
> in you msdn cd collection.
sorry, I did'nt read all (use > to quote!), use your computer name as domain
name (user name= PCNAME\USERNAME), or use a system account (if you don't
remember your password), or create a new user in xp (in the administrator
group).|||Thanks Giuseppe,
I was installing the developer edition.
dennist685
"Giuseppe Battaglia" wrote:
> "dennist685" <dennist685@.discussions.microsoft.com> wrote in message
> news:9ABFFC87-5999-4FDE-83D8-84E1CC3BF0E7@.microsoft.com...
> >I tried the following question in setup, but didn't get an answer. I think
> > not being able to install sqlserver 2000 is a serious problem. I'd
> > appreciate any help.
> >
> > thanks.
> >
> > dennist685
> >
> > When I try to install sql server 2000 I get the following message.
> >
> > Microsoft sql server 2000 enterprise edition server component is not
> > supported on this operating system. Only client components will be
> > available
> > for installation.
> >
> > I have xp pro.
> >
> > I have never installed sql server 2000 before.
> >
> > If client components are sufficient, how do I configure the security as
> > simple as possible. For now, just so I can sign in with all rights, with
> > as
> > little typing as possible.
> >
> > I went this far before cancelling. I clicked setup(I have the msdn DVD
> > version). After clicking next a few times it gave me the choice of client
> > tools only or connectivity only. The option button for server and client
> > tools was greyed out.
> >
> > I have adsl and an ethernet card for the adsl, but I am not connected to
> > any
> > sqlserver 2000.
> >
> > Please help.
> >
> > dennist685
> >
> > Hi,
> >
> > The server components of the Enterprise Edition could not be installed on
> > xp.
> > You should use the Developer Edition if you want to install all components
> > on xp.
> > If you do not have any server component available, client components only
> > will not provide the ability to create databases/tables..
> >
> > Lionel
> >
> > my answer
> >
> > Thanks Lionel. I chose the developer edition, server and client tools.
> > However when I get to services accounts I accepted the default - use a
> > domain
> > user account. It had the username I use for logon to windows -
> > dennist685.
> > the domain name was my first name in Caps. I tried several passwords, but
> > got
> > the following error message:
> >
> > The logon account cannot be validated for the sql server service. Verify
> > that the user name and password entered are correct. The logon attempt
> > failed.
> >
> > Any ideas?
> >
> > dennist685
> On xp you can install only the "desktop" or "developer" edition. Find it in
> you msdn cd collection.
>
>|||You can use your own network login for the service accounts on your
workstation but you need to be connected to the domain and you must have
local admin privleges.
Otherwise, the other options Giuseppe provide would be good alternatives.
Remember, if you use your own credentials, you will need to reset the
service account passwords whenever you change your password.
Sincerely,
Anthony Thomas
"dennist685" <dennist685@.discussions.microsoft.com> wrote in message
news:6F2716E5-9592-4E87-9E0D-C461399ADC84@.microsoft.com...
Thanks Giuseppe,
I was installing the developer edition.
dennist685
"Giuseppe Battaglia" wrote:
> "dennist685" <dennist685@.discussions.microsoft.com> wrote in message
> news:9ABFFC87-5999-4FDE-83D8-84E1CC3BF0E7@.microsoft.com...
> >I tried the following question in setup, but didn't get an answer. I
think
> > not being able to install sqlserver 2000 is a serious problem. I'd
> > appreciate any help.
> >
> > thanks.
> >
> > dennist685
> >
> > When I try to install sql server 2000 I get the following message.
> >
> > Microsoft sql server 2000 enterprise edition server component is not
> > supported on this operating system. Only client components will be
> > available
> > for installation.
> >
> > I have xp pro.
> >
> > I have never installed sql server 2000 before.
> >
> > If client components are sufficient, how do I configure the security as
> > simple as possible. For now, just so I can sign in with all rights,
with
> > as
> > little typing as possible.
> >
> > I went this far before cancelling. I clicked setup(I have the msdn DVD
> > version). After clicking next a few times it gave me the choice of
client
> > tools only or connectivity only. The option button for server and
client
> > tools was greyed out.
> >
> > I have adsl and an ethernet card for the adsl, but I am not connected to
> > any
> > sqlserver 2000.
> >
> > Please help.
> >
> > dennist685
> >
> > Hi,
> >
> > The server components of the Enterprise Edition could not be installed
on
> > xp.
> > You should use the Developer Edition if you want to install all
components
> > on xp.
> > If you do not have any server component available, client components
only
> > will not provide the ability to create databases/tables..
> >
> > Lionel
> >
> > my answer
> >
> > Thanks Lionel. I chose the developer edition, server and client tools.
> > However when I get to services accounts I accepted the default - use a
> > domain
> > user account. It had the username I use for logon to windows -
> > dennist685.
> > the domain name was my first name in Caps. I tried several passwords,
but
> > got
> > the following error message:
> >
> > The logon account cannot be validated for the sql server service.
Verify
> > that the user name and password entered are correct. The logon attempt
> > failed.
> >
> > Any ideas?
> >
> > dennist685
> On xp you can install only the "desktop" or "developer" edition. Find it
in
> you msdn cd collection.
>
>|||Thanks Anthony and Giuseppe
But, I can't say I know what you're talking about.
I have no password for the dennist685 xp account. It's the only account,
the only account I want, and I was never asked for a password in the xp pro
installation. I fully installed iis with frontpage extensions.
What do you mean by network login? The login my ISP gave me to connect to
ADSL? I'm not part of any network. Mine is a lone computer connected to the
internet through an ADSL. I don't know what is meant by own credentials.
I also have no idea what this sentence means: You can use your own network
login for the service accounts on your
workstation but you need to be connected to the domain and you must have
local admin privleges.
or how to do it. What I need is just the simplest way to install sqlserver
2000, any edition, on xp pro. given my only account is dennist685, and there
is no password. My ISP account is also named dennist685. To that there is a
password and I tried it with the error above.
You're dealing with a real newbie here. Up to now I've been dealing with
Microsoft Access databases.
Thanks.
dennist685|||What I really want to know is the following. When I reach the point
specified, what should I type so that the installation proceeds.
Alternatively, what choices should I be making earlier in the installation
so that the screen in question works.
thanks.
dennist685|||On Sun, 5 Dec 2004 03:13:01 -0800, "dennist685"
<dennist685@.discussions.microsoft.com> wrote:
>Thanks Anthony and Giuseppe
>But, I can't say I know what you're talking about.
>I have no password for the dennist685 xp account. It's the only account,
>the only account I want, and I was never asked for a password in the xp pro
>installation. I fully installed iis with frontpage extensions.
>What do you mean by network login? The login my ISP gave me to connect to
>ADSL? I'm not part of any network. Mine is a lone computer connected to the
>internet through an ADSL. I don't know what is meant by own credentials.
>I also have no idea what this sentence means: You can use your own network
>login for the service accounts on your
>workstation but you need to be connected to the domain and you must have
>local admin privleges.
> or how to do it. What I need is just the simplest way to install sqlserver
>2000, any edition, on xp pro. given my only account is dennist685, and there
>is no password. My ISP account is also named dennist685. To that there is a
>password and I tried it with the error above.
>You're dealing with a real newbie here. Up to now I've been dealing with
>Microsoft Access databases.
>
Use the "local system" option. That will work. (Unless you limited the
permissions for SYSTEM, which is unlikely)
Joachim.
--
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen (jcdverha@.xs4all.nl)
WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||Joachim,
I got it installed. We got that far. However, when I view server explorer,
after a bunch of databases (all access)I get servers. under servers dennis.
One more indent a bunch of things ending in SQL Servers. Under that, one
indent more, is DENNIS. If I click the box for that, the screen freezes up
for awhile, then I finally get a login box that says
Server Dennis(textbox disabled)
Database blank (textbox disabled)
checkbox, unchecked, use NT integrated security
Login dennist685 (textbox enabled)
Password (blank (textbox enabled)
buttons OK, Cancel, Help
Help is unhelpful
If I click OK, nothing happens
If I click use NT sercurity and then OK, the screen freezes for a minute.
Then I get the message
[DTNETLIB[]ConnectionOpen(Connect(),]SL Server does not exist or access
denied.
dennist685
"Joachim Verhagen" wrote:
> On Sun, 5 Dec 2004 03:13:01 -0800, "dennist685"
> <dennist685@.discussions.microsoft.com> wrote:
> >Thanks Anthony and Giuseppe
> >
> >But, I can't say I know what you're talking about.
> >
> >I have no password for the dennist685 xp account. It's the only account,
> >the only account I want, and I was never asked for a password in the xp pro
> >installation. I fully installed iis with frontpage extensions.
> >What do you mean by network login? The login my ISP gave me to connect to
> >ADSL? I'm not part of any network. Mine is a lone computer connected to the
> >internet through an ADSL. I don't know what is meant by own credentials.
> >
> >I also have no idea what this sentence means: You can use your own network
> >login for the service accounts on your
> >workstation but you need to be connected to the domain and you must have
> >local admin privleges.
> > or how to do it. What I need is just the simplest way to install sqlserver
> >2000, any edition, on xp pro. given my only account is dennist685, and there
> >is no password. My ISP account is also named dennist685. To that there is a
> >password and I tried it with the error above.
> >
> >You're dealing with a real newbie here. Up to now I've been dealing with
> >Microsoft Access databases.
> >
> Use the "local system" option. That will work. (Unless you limited the
> permissions for SYSTEM, which is unlikely)
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen (jcdverha@.xs4all.nl)
> WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>|||I don't remember exactly what I did, but it seems installed now with all the
sample databases installed as well. 'Seems' is the operative word.
dennist685
"Joachim Verhagen" wrote:
> On Sun, 5 Dec 2004 03:13:01 -0800, "dennist685"
> <dennist685@.discussions.microsoft.com> wrote:
> >Thanks Anthony and Giuseppe
> >
> >But, I can't say I know what you're talking about.
> >
> >I have no password for the dennist685 xp account. It's the only account,
> >the only account I want, and I was never asked for a password in the xp pro
> >installation. I fully installed iis with frontpage extensions.
> >What do you mean by network login? The login my ISP gave me to connect to
> >ADSL? I'm not part of any network. Mine is a lone computer connected to the
> >internet through an ADSL. I don't know what is meant by own credentials.
> >
> >I also have no idea what this sentence means: You can use your own network
> >login for the service accounts on your
> >workstation but you need to be connected to the domain and you must have
> >local admin privleges.
> > or how to do it. What I need is just the simplest way to install sqlserver
> >2000, any edition, on xp pro. given my only account is dennist685, and there
> >is no password. My ISP account is also named dennist685. To that there is a
> >password and I tried it with the error above.
> >
> >You're dealing with a real newbie here. Up to now I've been dealing with
> >Microsoft Access databases.
> >
> Use the "local system" option. That will work. (Unless you limited the
> permissions for SYSTEM, which is unlikely)
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen (jcdverha@.xs4all.nl)
> WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>|||SQLServer always installs with the sample databases, so you must have them.
The most likely cause is that SQLServer is not running. (SQLServer is a
service, not just a file like MSaccess). At the right of the taskbar you
should have an icon looking like a tower model computer with a circle on it.
If the circle shows a green arrow, SQLServer is running, if it shows a red
square it is not. If you see a red square you should double click the icon
and start SQLServer.
SQLServer comes with a tool called the enterprise manager. Start it up from
the start menu->programs->Microsoft SQLServer. You can easily manage
SQLServer with it. Navigate around and use right-clicks to see what actions
you can do.
Joachim.
On Mon, 6 Dec 2004 03:35:05 -0800, "dennist685"
<dennist685@.discussions.microsoft.com> wrote:
>I don't remember exactly what I did, but it seems installed now with all the
>sample databases installed as well. 'Seems' is the operative word.
>dennist685
>"Joachim Verhagen" wrote:
>> On Sun, 5 Dec 2004 03:13:01 -0800, "dennist685"
>> <dennist685@.discussions.microsoft.com> wrote:
>> >Thanks Anthony and Giuseppe
>> >
>> >But, I can't say I know what you're talking about.
>> >
>> >I have no password for the dennist685 xp account. It's the only account,
>> >the only account I want, and I was never asked for a password in the xp pro
>> >installation. I fully installed iis with frontpage extensions.
>> >What do you mean by network login? The login my ISP gave me to connect to
>> >ADSL? I'm not part of any network. Mine is a lone computer connected to the
>> >internet through an ADSL. I don't know what is meant by own credentials.
>> >
>> >I also have no idea what this sentence means: You can use your own network
>> >login for the service accounts on your
>> >workstation but you need to be connected to the domain and you must have
>> >local admin privleges.
>> > or how to do it. What I need is just the simplest way to install sqlserver
>> >2000, any edition, on xp pro. given my only account is dennist685, and there
>> >is no password. My ISP account is also named dennist685. To that there is a
>> >password and I tried it with the error above.
>> >
>> >You're dealing with a real newbie here. Up to now I've been dealing with
>> >Microsoft Access databases.
>> >
>> Use the "local system" option. That will work. (Unless you limited the
>> permissions for SYSTEM, which is unlikely)
>> Joachim.
>> --
>> This post is free post; you can redistribute it and/or
>> modify it under the terms of the GNU General Public License
>> as published by the Free Software Foundation; either version 2
>> of the License, or (at your option) any later version.
>> Joachim Verhagen (jcdverha@.xs4all.nl)
>> WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)
--
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen (jcdverha@.xs4all.nl)
WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||I hate to tell you, Joachim, but the tower doesn't appear in my taskbar.
What does that mean?
dennist685
"Joachim Verhagen" wrote:
> SQLServer always installs with the sample databases, so you must have them.
> The most likely cause is that SQLServer is not running. (SQLServer is a
> service, not just a file like MSaccess). At the right of the taskbar you
> should have an icon looking like a tower model computer with a circle on it.
> If the circle shows a green arrow, SQLServer is running, if it shows a red
> square it is not. If you see a red square you should double click the icon
> and start SQLServer.
> SQLServer comes with a tool called the enterprise manager. Start it up from
> the start menu->programs->Microsoft SQLServer. You can easily manage
> SQLServer with it. Navigate around and use right-clicks to see what actions
> you can do.
> Joachim.
>
> On Mon, 6 Dec 2004 03:35:05 -0800, "dennist685"
> <dennist685@.discussions.microsoft.com> wrote:
> >I don't remember exactly what I did, but it seems installed now with all the
> >sample databases installed as well. 'Seems' is the operative word.
> >
> >dennist685
> >
> >"Joachim Verhagen" wrote:
> >
> >> On Sun, 5 Dec 2004 03:13:01 -0800, "dennist685"
> >> <dennist685@.discussions.microsoft.com> wrote:
> >>
> >> >Thanks Anthony and Giuseppe
> >> >
> >> >But, I can't say I know what you're talking about.
> >> >
> >> >I have no password for the dennist685 xp account. It's the only account,
> >> >the only account I want, and I was never asked for a password in the xp pro
> >> >installation. I fully installed iis with frontpage extensions.
> >> >What do you mean by network login? The login my ISP gave me to connect to
> >> >ADSL? I'm not part of any network. Mine is a lone computer connected to the
> >> >internet through an ADSL. I don't know what is meant by own credentials.
> >> >
> >> >I also have no idea what this sentence means: You can use your own network
> >> >login for the service accounts on your
> >> >workstation but you need to be connected to the domain and you must have
> >> >local admin privleges.
> >> > or how to do it. What I need is just the simplest way to install sqlserver
> >> >2000, any edition, on xp pro. given my only account is dennist685, and there
> >> >is no password. My ISP account is also named dennist685. To that there is a
> >> >password and I tried it with the error above.
> >> >
> >> >You're dealing with a real newbie here. Up to now I've been dealing with
> >> >Microsoft Access databases.
> >> >
> >>
> >> Use the "local system" option. That will work. (Unless you limited the
> >> permissions for SYSTEM, which is unlikely)
> >>
> >> Joachim.
> >>
> >> --
> >> This post is free post; you can redistribute it and/or
> >> modify it under the terms of the GNU General Public License
> >> as published by the Free Software Foundation; either version 2
> >> of the License, or (at your option) any later version.
> >>
> >> Joachim Verhagen (jcdverha@.xs4all.nl)
> >> WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)
> >>
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen (jcdverha@.xs4all.nl)
> WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>|||I rebooted my system and the tower was right there in the taskbar.
thanks muchly,
dennist685
"Joachim Verhagen" wrote:
> SQLServer always installs with the sample databases, so you must have them.
> The most likely cause is that SQLServer is not running. (SQLServer is a
> service, not just a file like MSaccess). At the right of the taskbar you
> should have an icon looking like a tower model computer with a circle on it.
> If the circle shows a green arrow, SQLServer is running, if it shows a red
> square it is not. If you see a red square you should double click the icon
> and start SQLServer.
> SQLServer comes with a tool called the enterprise manager. Start it up from
> the start menu->programs->Microsoft SQLServer. You can easily manage
> SQLServer with it. Navigate around and use right-clicks to see what actions
> you can do.
> Joachim.
>
> On Mon, 6 Dec 2004 03:35:05 -0800, "dennist685"
> <dennist685@.discussions.microsoft.com> wrote:
> >I don't remember exactly what I did, but it seems installed now with all the
> >sample databases installed as well. 'Seems' is the operative word.
> >
> >dennist685
> >
> >"Joachim Verhagen" wrote:
> >
> >> On Sun, 5 Dec 2004 03:13:01 -0800, "dennist685"
> >> <dennist685@.discussions.microsoft.com> wrote:
> >>
> >> >Thanks Anthony and Giuseppe
> >> >
> >> >But, I can't say I know what you're talking about.
> >> >
> >> >I have no password for the dennist685 xp account. It's the only account,
> >> >the only account I want, and I was never asked for a password in the xp pro
> >> >installation. I fully installed iis with frontpage extensions.
> >> >What do you mean by network login? The login my ISP gave me to connect to
> >> >ADSL? I'm not part of any network. Mine is a lone computer connected to the
> >> >internet through an ADSL. I don't know what is meant by own credentials.
> >> >
> >> >I also have no idea what this sentence means: You can use your own network
> >> >login for the service accounts on your
> >> >workstation but you need to be connected to the domain and you must have
> >> >local admin privleges.
> >> > or how to do it. What I need is just the simplest way to install sqlserver
> >> >2000, any edition, on xp pro. given my only account is dennist685, and there
> >> >is no password. My ISP account is also named dennist685. To that there is a
> >> >password and I tried it with the error above.
> >> >
> >> >You're dealing with a real newbie here. Up to now I've been dealing with
> >> >Microsoft Access databases.
> >> >
> >>
> >> Use the "local system" option. That will work. (Unless you limited the
> >> permissions for SYSTEM, which is unlikely)
> >>
> >> Joachim.
> >>
> >> --
> >> This post is free post; you can redistribute it and/or
> >> modify it under the terms of the GNU General Public License
> >> as published by the Free Software Foundation; either version 2
> >> of the License, or (at your option) any later version.
> >>
> >> Joachim Verhagen (jcdverha@.xs4all.nl)
> >> WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)
> >>
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen (jcdverha@.xs4all.nl)
> WWW http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>
8) [10:44:52:780]: Note: 1: 1708