sql server new users: Hi,

I am having issues running SQL server 2000 on my XP box. after installation
I am unable to gain access to the local server group. I get continual log in
errors. I am unable to regisiter new servers. SQL server just wont start.

I have installed and uninstalled a couple of times with different
configurations. Still no luck. I am using the SQL 2000 developer edition.

any advice?

thanks

Andrew K

Hi Andrew,

Is SQL Server not starting or are you unable to log in (or both)?

To check if SQL Server is starting, take a look the "services" section of
Administrative Tools under Control Panel (alternately go to "Services" after
right-clicking My Computer and selecting "Manage"). If the service isn't
started, try to start it. If it won't start, check the System Event Log and
you'll usually find an error in there.

If SQL Server is starting, try connecting using Windows Authentication while
logged in as a member of the local administrators group on the system.

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]