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.
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: 0x800401F017120 :SQL Server could not spawn FRunCM thread.Error: 17059, Severity: 18, State: 0Operating system error -1073723998: .Error: 17826, Severity: 18, State: 1Could 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 AthalyeIndia."Nothing is Impossible" |
|
|
rumpus
Starting Member
3 Posts |
Posted - 2006-10-13 : 01:01:21
|
please excuse my ignorance but where do I find that? |
|
|
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)OR1. Click on Start menu, Run2. Type cliconfg (Client Network Utility) or type svrnetcn (Server Network Utility)Harsh AthalyeIndia."Nothing is Impossible" |
|
|
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.CheersA |
|
|
|
|
|
|
|