I have SQL Server 2005 Express running on a Server 2003 server.
I *think* that I have remote connections enabled correctly as i can connect to the db from any of the machines on the LAN via the server name or it's ip address.
i need to be able to connect to the db from outside the LAN - ie from home, or on the road, using my router's ip address.
i have opened a port in my routers firewall and forwarded that to the ip of the server.
The browser service is running, and remote connections are enabled via TCP/IP and NamedPipes
If I try using my program, which works if i use the internal 192.168.1.x address or the server name in the connection string, i get the following:
System.Data.SqlClient.SqlException: 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.)
i have tried using SQL Server Management Express also using
and i get the same error - but i can connect using the 192.168.1.xxx and server name.
what am i missing?