No connection could be made because the target machine actively refused it
Posted on 2007-11-18
I have a SQL Server 2005 Express installed on my Intranet server that resides in my DMZ.
I have access from my LAN to my DMZ open.
I have the SQL Server configured to allow remote connections to the server.
When I attempt to access the Database services from my "Microsot SQL Server Management Studio" 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 under the default settings SQL Server does not
allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because
the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
When I attempt to establisg a connection through ODBC. I get the following error:
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
Could an expert please give me some clues at what may be wrong.