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 |
|
ermiassene
Starting Member
5 Posts |
 Posted - 2008-02-19 : 03:08:15
|
| Please help me. I can't work, this kind of message block my project, give ur suggestion ..Message="An error has occurred whileestablishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQLServer does not allow remote connections. (provider: Named Pipes Provider,error: 40 - Could not open a connection to SQL Server)" please everybodycooperate me |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-19 : 03:22:28
|
| go to the surface area configuration and allow remote connections. |
 |
|
|
ermiassene
Starting Member
5 Posts |
Posted - 2008-02-19 : 13:20:53
|
| Thanks for your reply,but it couldn't work . I am checking in the surface area in different way. If u can ,please give me anather way in detail including the procedure. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:00:03
|
| Is sql server browser service running? Enabled tcp/ip or named pipes protocol on the server? |
|
|
|
ermiassene
Starting Member
5 Posts |
Posted - 2008-02-22 : 01:41:13
|
| thank you ,but it couldn't work. my computer is not in a network .I check all the posible ways of configuring the sql server manager and surface area configuration .If u know other method or the sql server is difficult for configuring the stand alone computer,please describe me. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 15:19:34
|
| How can you you make remote connection if there is no network? |
|
|
|
ermiassene
Starting Member
5 Posts |
Posted - 2008-02-26 : 02:09:55
|
| i was disable the remote connection,i make it local connection ,it couldn't work i change in the surface area config. local and remote connection ,but still it has problem please describe me? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-26 : 22:06:11
|
| Still don't understand what you try to do. |
|
|
|
|
|
|
SQL Server 2005 connection problem