installation problems

From: dennist685 (dennist685_at_discussions.microsoft.com)
Date: 12/04/04


Date: Fri, 3 Dec 2004 23:49:01 -0800

I tried this question in sqlserver.setup without a solution. Since it got
stuck on a security issue I'll try it here.

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