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 |
|
Matt5092
Starting Member
6 Posts |
 Posted - 2007-10-08 : 07:18:14
|
Hi there,Previously SQL2005 was running fine on my machine and I usually leave my machine on at all times.When I rebooted my machine over the weekend and logged back into windows, I was then unable to connect to the SQL server management studio with the following error being generated... I have it already set to allow remote connections The only issue I can see is that I can't get the SQL server agent to start... My collegue can connect to my server from his machine and likewise I can connec to his instance via my machine. Its just my own instance that I can't connect to for some reason.I also have all protocols enabled via the SQL server configeration.Thanks in advance,Matt |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-08 : 21:50:17
|
| You have to connect to sql server with tcp/ip protocol. Seems you set named pipes protocol as default one, double check that in sql configuration manager on your machine. |
 |
|
|
|
|
|
Connection problems