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
------------
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