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 |
|
sattar
Starting Member
2 Posts |
 Posted - 2008-07-04 : 01:58:48
|
| First of all iam using sql server express edition for first time and when i attempt to connect the following error message is displayed: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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)I tried configuring surface area configuration Ticked tcp/ip and named pipes connectionRestarted Data base engineBut still no luck can someone help me out with this problem it would be of great helpThanx |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2008-07-04 : 06:27:29
|
| SQL server 2005 express edition does not accept network connection, are you trying to access it outside the machine? ie. from another machine? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 21:10:32
|
| Yes, sql2k5 express accepts remote connection. You need enable tcp/ip or named pipes protocol in configureation manager, and enable remote connection in surface area configuration. |
|
|
|
sattar
Starting Member
2 Posts |
Posted - 2008-07-05 : 00:06:02
|
| hai rmio i did that bit still it doesnt work |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-05 : 23:50:08
|
| Got same error? Did you specify correct instance name? Is sql browser service running? |
|
|
|
|
|
|
Sql Server connection problems