I'm trying to get SQL running for my SQL introduction course the following are answers to some questions that my instructer sent me. I’ve gotten this issue from both the SQL 2000 Standard ed. (on CD) and the SQL 2000 Personal 120day trail version on both systems now. Both are networked together through a HUB but I have no stand alone server here. My first attempts have been on getting this running on my main system under WinXP but I just tried it on my second system and its running WINME. It also failed? Is there some ADMIN rights or some prerequisite that I'm missing here to get this running on just one system?
------------

INSTRUCTOR: In XP Iv'e double checked and my computers name is LARRY. Check your computers NAME & Don't use the period!
ANSWER: = Computer Name is LARRY
(I use to have three systems...Larry, Curly, Mo! :))

INSTRUCTOR: QNow go back into SQL Server.
ANSWER = I opened Enterprise Manager form the start menu.

INSTRUCTOR: Click on "Microsoft SQL Servers" under "Console Root".
ANSWER = To get "New SQL Server Registration" to show, I highlight SQL SERVER GROUP.
Under the CONSOLE ROOT tree there is only:
CONSOLE TREE
-MICROSOFT SQL SERVERS
-SQL SERVER GROUP*

INSTRUCTOR: Under "Action" Click "New SQL Server Registration"
ANSWER = New SQL Server Registration is only available if I select -SQL SERVER GROUP*

INSTRUCTOR: Under "Available Servers" type the full name of your computer
ANSWER = The Register SQL Server Wizard dispalys the Available server LARRY already.
(Note - NO PERIOD!)

INSTRUCTOR: Click ADD then click NEXT
ANSWER = I selact ADD. LARRY is now in Added Servers.

NEXT.

INSTRUCTOR: Select the first option (The Windows NT account.....)
ANSWER = First option its there and selected.
Select an Authertication Mode:
_X_ The Windows account information I use to log on to my Computer.
(Windows Autheritication.)

NEXT

INSTRUCTOR: Select the first option (Add the SQL Server....)
ANSWER = I selected the first option.
_X_ Add the SQL Server(s) to an existing SQL server group.
Group Name: SQL Server Group

Next

INSTRUCTOR: WAIT a MINUTE then Click Finish
ANSWER = Waited - DONE It says ......

The Register SQL server Messages, Server registration completed.
Status: LARRY - SQL Server does not exist or access denied. Connection Open.

INSTRUCTOR: Next, Select Tools-SQL Query Analyzer
ANSWER = DONE

INSTRUCTOR: Click Start SQL Server if it is stopped.
And select first option (Use Windows NT......) click OK

ANSWER:
---------<WINDOW>---------------------
* Connect to SQL Server *
SQL Server____________ [..]
_X_ Start SQL Server if it is stopped.

Connect Using -
_X__ Windows Autheritcation
___ SQL Server Autheritication
Login Name:__SA__________________
Password: ____________________
<OK> <CANCEL> <HELP>
--------------------------------------
(Note SQL Server____________ is empty, there is nothing in [..] ).

THE ERROR:
After selecting <OK> the system does its thing and then there is:

-------<Window>---------
SQL QUERY ANALYZER

Unable to connect to server Larry:

Server: Msg 17, Level 16, State 1
[Microsoft][QDBC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied.

< OK >
------------------------

That is it. I have the feeling that there is possibly some permission setup or permission default that I have not setup correctly before installing SQL? I have chacked and the user that I am using here is listed as having Admin Rights! Any ideas? Thanks for your time.

Sincerely.
K

Hello Sandman38 , Assuming you installed a new Sql server 2000

MsSql by default has sa as a user.

During the installation of this sql server there may have been a request to add a password for the sa user account.

Is SQL server running ?

Check in the services or run sqlmangr.exe to start and stop sql services.

Sql Server and Sql agent should be running. Sql Manager will visually show you the name of the sql server

to type into the enterprise manager server registration window.

connect using sql authentication with sa as the user and a password if required or blank.

I do not think XP home edition/ Professional allows for NT authentication for Sql server connections.

I have MSSQL server 200 running and can connect via Enterprise manager under XP home edition.

Give the above a whirl and ask some more questions.

If you don't remember the password for sa , uninstall SQL server and reinstall , is easy as

you have no data in a new install to protect anyway. Write down the password on the next install.

thanks cornball

Thanks Cornball

But since I wrote this issue I replaced my 2nd systems removable HD (WinME)with a HD (Win2000). Issues fixed.