Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 local MSSQLSERVER wont start

Author  Topic 

rumpus
Starting Member

3 Posts

Posted - 2006-10-12 : 23:48:51
Hi there, my sql server on my development machine wont start. I get the error message 'System.Data.SqlClient.SqlException: SQL Server does not exist or access denied'. I cant start it manually from the services window either, or connect to it with Enterprise Manager.

In the event logs:
Failed to connect to server. Error: 0x800401F0

17120 :
SQL Server could not spawn FRunCM thread.

Error: 17059, Severity: 18, State: 0
Operating system error -1073723998: .

Error: 17826, Severity: 18, State: 1
Could not set up Net-Library 'SSNETLIB'.

19015 :
Encryption requested but no valid certificate was found. SQL Server terminating.

Not sure why this happened as it just stopped working for some reason.

Any help would be great.
Thanks, A


harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-13 : 00:57:55
In the client Network Utility and Server Network Utility, under General tab, uncheck Force Protocol Encryption check box.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

rumpus
Starting Member

3 Posts

Posted - 2006-10-13 : 01:01:21
please excuse my ignorance but where do I find that?
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-13 : 01:21:07
1. Click on Start Menu, Programs, Microsoft SQL Server, Server Network Utility (same applicable for Client Network Utility)

OR

1. Click on Start menu, Run
2. Type cliconfg (Client Network Utility) or
type svrnetcn (Server Network Utility)


Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

rumpus
Starting Member

3 Posts

Posted - 2006-10-14 : 00:09:45
Hey, thanks for that. All is working now. For some reason my connection strings dont work without np: in front of the server name now but I'm up and running again thanks to you.

Cheers
A
Go to Top of Page
   

- Advertisement -