|
Home > Archive > MS SQL Server > November 2006 > Microsoft SQL Server, Error: 10060
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Microsoft SQL Server, Error: 10060
|
|
| tootsuite@gmail.com 2006-11-28, 7:14 pm |
| Every now and then I receive this error, usually when trying to
establish a connection to a new server. I checked and confirmed in
surface area configuration that remote connections are enabled across
tcp/ip. Also there are no firewall issues. This is sql server 2005. Any
ideas? Thank you.
TITLE: Connect to Server
------------------------------
Cannot connect to magneto2.
------------------------------
ADDITIONAL INFORMATION:
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.) (Microsoft SQL Server, Error: 10060)
For help, click:
http://go.microsoft.com/fwlink? Pro...60&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
| |
| John Bell 2006-11-30, 7:14 pm |
| Hi
As this is periodic it does not seem to be the configuration that is
necessarily the issue. Check the network settings and routing. Also check if
TCP/IP is the protocol being used. Virus scanners can effect communications
if named pipes are being used. See
http://support.microsoft.com/kb/309422/en-us and
http://support.microsoft.com/kb/827422/en-us
John
"tootsuite@gmail.com" wrote:
> Every now and then I receive this error, usually when trying to
> establish a connection to a new server. I checked and confirmed in
> surface area configuration that remote connections are enabled across
> tcp/ip. Also there are no firewall issues. This is sql server 2005. Any
> ideas? Thank you.
>
> TITLE: Connect to Server
> ------------------------------
>
> Cannot connect to magneto2.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> 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.) (Microsoft SQL Server, Error: 10060)
>
> For help, click:
> http://go.microsoft.com/fwlink? Pro...60&LinkId=20476
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
|
|
|
|
|