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 |
|
Dasman
Yak Posting Veteran
79 Posts |
 Posted - 2011-06-16 : 13:22:37
|
| Hello All,This morning the server I always connect to daily and it is on the local network since it does not require internet (as my mentor told me.)Now as I login and enter the correct password I recieve this error:"a network-related or instance-specific error occurred while establishing a connection to SQL Server. Ther server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"==========================Pain is Weakness Leaving the Body. |
|
|
Dasman
Yak Posting Veteran
79 Posts |
Posted - 2011-06-16 : 13:23:22
|
| Just to Update:I have rebooted both SQL Server Management Studio and the computer itself several times - no luck! :(==========================Pain is Weakness Leaving the Body. |
 |
|
|
Dasman
Yak Posting Veteran
79 Posts |
Posted - 2011-06-17 : 11:02:40
|
| The Problem: Multiple Concurrent Connections happened on my XP system. Since I don't run a server OS - the SQL server crashed. What I had to do was quit and restart the server - which fixed the problem!==========================Pain is Weakness Leaving the Body. |
|
|
|
|
|
|
Urgent Help Needed - Server Connection Problem