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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2008-07-21 : 09:39:57
|
| Hi,When trying to connect to a server in sql 2005 i get the following error:An 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)How can I solve this?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
mdubey
Posting Yak Master
133 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 22:47:39
|
| And ensure you enabled remote access with tcp/ip or named pipes protocol. |
 |
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2008-07-22 : 03:51:28
|
| The server doesn't exist. It has been deleted by someone.Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2008-07-22 : 03:52:05
|
| Where are my manners this morning? Thanks guys for the help :-)Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
|
|
|
can't open server