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 |
|
etschris
Starting Member
2 Posts |
 Posted - 2006-09-12 : 21:53:58
|
| I am having a really difficult time in resolving a problem with my SQL Server 2005. It is "randomly" throwing this 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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)In another post I saw someone made a suggestion to edit the "SQL Server Surface Area Configuration." However, "TCP/IP and Named Pipes" was already enabled for remote systems.I did make a change to the Server Surface Area Configuration to allow only "TCP/IP" to see if that helps.The most frustrating part is this error happens randomly and I can not reproduce it consistently, but if I hit my web site enough times, it will eventually throw the above error.I saw on another forum site to turn off pooling in the connection string? Thoughts?So far I have not seen anything out on the web, books online, MSDN, or anywhere that people are experiencing this error. Frustrated.... Chris |
|
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-09-17 : 16:17:27
|
| did you install SP1 for your sql server 2005?Check if RemoteConnection was selected- default is just Local:SQL Server Surface Area Configuration-DatabaseEngine _>RemoteConnectionalso check:Troubleshoot Connectivity Issue in SQL Server 2005 - Part IIIhttp://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx |
 |
|
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-09-17 : 16:19:41
|
| looks like you did it..so check link then |
|
|
|
|
|
|
Connection Errors in SQL 2005