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 |
|
alxtech
Yak Posting Veteran
66 Posts |
 Posted - 2007-11-09 : 10:16:14
|
| Hello Forum,after installing 2005, if trying to connect to local server it is giving me the following error: cannot connect to ols00038An 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) (Microsoft SQL Server, Error:2) |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-09 : 12:27:54
|
| you have to enable tcp connections in surface area configuration.if you have that also try disabling the firewall if you have one._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-11-09 : 13:09:40
|
| check ur server_name\instance_name is given correctly,check the service status of ur server in surface area configuration.RKNAIR |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-09 : 23:30:09
|
| And ensure sql server browser service is running. |
|
|
|
|
|
|
cannot connect locally