cannot connect to the local instance

I have SQL server 2000 installed on my machine,
Under the "SQL Server Group" , if I click on the local insatnce (computerNam
e\NETSDK(window NT)) , I get the following error:
"The SQL server \\computerName\NETSDK is not known to be running, are you s
ure you wish to connect"
if I click yes, I get this second error message:
"A connection could not be established to computername/NETSDK.
Reason: SQL server does not exist or access denied.
ConnectionOpen(Connect())...
Please verify SQL Server is running and check your SQL Server registration p
roperties..."
when I check the registration, nothing look unusual for me.
thanks for helpYou didn't indicate whether you verified that the MSSQLServer service was
running. If so, are you using windows authentication or SQL authentication?
If you are using Windows authentication, try the sa account (assuming you
know/remember the password and that the server is in mixed mode). If you
get in using sa, check to be sure that you haven't removed the
builtin\administrators login without also adding your own. People tend to
forget this and get themselves locked out...
"tony" <myemail@.mail.com> wrote in message
news:2C272FD6-7C9E-441D-9AB7-DE70AC17946F@.microsoft.com...
> I have SQL server 2000 installed on my machine,
> Under the "SQL Server Group" , if I click on the local insatnce
(computerName\NETSDK(window NT)) , I get the following error:
> "The SQL server \\computerName\NETSDK is not known to be running, are you
sure you wish to connect"
> if I click yes, I get this second error message:
> "A connection could not be established to computername/NETSDK.
> Reason: SQL server does not exist or access denied.
> ConnectionOpen(Connect())...
> Please verify SQL Server is running and check your SQL Server registration
properties..."
> when I check the registration, nothing look unusual for me.
> thanks for help
>|||Hi Tony,
Thank you for using the newsgroup and thanks for Don's reply.
Don have pointed out some place you should check first and here I just want
to add some more information for your reference. You could look at this
following article:
INF: Potential Causes of the "SQL Server Does Not Exist or Access Denied"
Error Message
http://support.microsoft.com/?id=328306
Hope this help. If you still have questions, please feel free to post
message here and we are glad to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||the problem occured while backing up a database, the backup failed and I los
t connection to my local instance.
SQL server(as interface) is running fine on my machine and I can connect to
other remote server but not to the local one.
when I try to register the local one (under 'SQL Server Group') , I get an e
rror message saying that 'SQL Server does not exist or .....)
when I check the service, SQLServer service does not have even an entry an
d I couldn't locate it as a service.
I uninstalled SQL server (client tool) and I can still run the client on my
machine as if I didn't uninstall it, but with no connection to the local one
.
I installed it again and still getting the same error message.
The service does not exist, and SQL server is installed, how can that happen
s ?
thank you again.|||how can I add MSSQLServer as a service.
SQL server is running but does not have entry under the Service node.|||Hi Tony,
Thank you for your update.
It is a little strange now. Do you mean that after un-install the SQL
Server, and then in the Services Snap-in in the MMC, you cannot see the
SQL Server Service but your application could still connect to it? When a
SQL Server is running well on you computer, it should have the service
configured on your computer, no matter it is started or stopped.
I would like to narrow down the problem step-by-step
1) Please go to the command prompt ( 'Start'->'Run', then type in 'cmd' and
press Enter), then type 'net start', could you get any service of SQL
Server? It could be
MSSQLSERVER or MSSQL$<instance_name>.
2) If no, type in 'net start MSSQLSERVER, what's the message you get?
Note: For other SQL Server instance, type in 'net start
MSSQL$<The_Instance_Name>'
3) If it said
The MSSQLSERVER service is starting......
The MSSQLSERVER service was started successfully.
OR
The requested service has already been started.
Then you could be sure that the SQL Server is installed on your computer.
Then, please use the Enterprise Manager to register it.
Hope this helps.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Baisong,
Thank you for yall your help.
I reinstalled SQL server (client) again in order to see if it is going to ap
pear in the " Services Snap-in in the MMC",
and it INSTALLED SUCCEFULLY (as the install said) , and I run it, through
"Entreprise Manager", and I could connect to other remote sql servers, but w
hen I tried to register the local instance, I get a message :"SQL server doe
s not exist or..."
then I checked the Services Snap-in in the MMC, but still cannot see it or s
ee any SQL service at all.
Then I followed your instruction excatly:
1) when typing : "net start" , I can see all services except anything for SQ
L or MSSQL or .......
2) when typing : "net start MSSQLSERVER" , that's what I got: "The service
name is invalid"
After done all that, I create a shortcut for "Entreprise Manager" on the des
ktop, then I uninstalled SQL server again.
1) Now I cannot see "Microsoft SQL Sever" entry under start -> Programs ->
Microsoft Sql server anymore,
but the shortcut to it still exist on my desktop, and when I double click it
, it run normally as I didn't uninstall it, and I still
can run queries and connect to other remote servers except the local one, th
en I followed you instruction again, and got
the same message as I got before the uninstall; (nothing for MSSQL.... and
"The service name is inavlid").
Is there anyway to add MSSQLServer as a service in the Services Snap-in in t
he MMC manually ?
Thank you again|||Hi Tony,
Thank you for your update.
From your informtion, it seems you do not installed the SQL Server service
on you machine, just the SQL Server management tools such as the Enterprise
Manager or Query Analyzer.
So, I recommend you to un-installed the tools again. Then check your
Operating System and choose the right edition of SQL Server. Please refer
to the following article:
Operating Systems Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_ts_7eur.asp
Then, please re-intall the proper SQL Server 2000 by choosing 'Server and
Client Tools' selection during the intallation. After all the installation,
you will notice the SQL Server Service is in the Server snap-shot in the
MMC.
Hope this helps and if you still have question, please feel free to post
message here and I am glad to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.