Thursday, March 8, 2012

Connection failure

When I try to connect one one of our SQL Server databases using SQL Server
2005 client tools I get the following 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
inder the default setting SQL Server does not allow remote connections.
(Provider: TCP Provider, erro:0 - No connections could be made because the
target machine actively refused it.) (Microsoft SQL Server, Error: 10061).
I can connect to our other SQL Servers with no problem, and others users can
connect to the one I'm having problems with.
Any ideas?Problem now solved.
Problem was caused by an alias setup for the previous version of sql server.
Deling the alias solved the problem.
Gary
"Gary Watson" wrote:

> When I try to connect one one of our SQL Server databases using SQL Server
> 2005 client tools I get the following 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
> inder the default setting SQL Server does not allow remote connections.
> (Provider: TCP Provider, erro:0 - No connections could be made because the
> target machine actively refused it.) (Microsoft SQL Server, Error: 10061).
> I can connect to our other SQL Servers with no problem, and others users c
an
> connect to the one I'm having problems with.
> Any ideas?

No comments:

Post a Comment