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 |
|
blgnklc
Starting Member
1 Post |
 Posted - 2008-04-14 : 20:33:47
|
| An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, thisI use Microsoft Windows Vista Home ProfessionalI have already installed to my computer Microsoft SQL Server 2005 and SQL Serves Express. I used to successful to connect to the SQL Server but now I CAN NOT.Not: I try to run SQL Server 2005 but I can not, even I logged on to my computer with an administrator rights. On the other hand I can start and stop the SQL Server easily.As a result, how can I solve this problem?Thanks in advance.Bilgin KiliçAdditional DetailsAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-14 : 22:59:42
|
| Is sql service running? Is name pipes enabled? Tried connect with tcp/ip protocol? |
 |
|
|
|
|
|
An error has occurred while establishing a connect