Unable to connect to SQL DB

[freshegg]

hello,

my programming colleague is unable to connect to our SQL server outside of our network on his home pc.
The application cannot make a connection to the database, despite the username and password being correct (and working from this location) and no firewall blocking the access from the external IP or to the Web Server IP.

We even whitelisted his IP and allowed any IP to connect for a short period but still no joy - all works fine here and it is def not a firewall issue



Error message is: 'An error occured while dealing with the database: SQL Server does not exist or access denied'.

Thanks in advance

 

[DrSql]

Is there a VPN connection from his home to to your facility. First verify he is able to get through VPN, if you are in then its should be smilar to you are in work network. Also when you are externally, try to register the instance with IP address rather than SQL instance. If that works then go and setup an Alias in SQL Server==>Clinet Network Utility.

Dr.Sql
Good Luck.

 

[freshegg]

We are attempting connecting to the SQL database via an IP address.

We do not connect via VPN to the network here before attempting to access the SQL server. The home machine's IP address has the same access rights set on the firewall as the external facing IP address here.

 

[gmmastros]

You probably have a router somewhere. Usually, this is the first 'box' connected to your internet connection. You will need to configure the router to forward the SQL Server port to the machine hosting SQL Server. Most of the time, SQL Server uses port 1433.

I recommend you check your router. Get it working, and then immediately change the SQL Server port to something else.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[freshegg]

If we can make a connection okay to the SQL server from one IP address then whatever routing is in place at the server side hosting end is working correctly.

From the remote locations trying to hit the SQL server, we are attempting to connect on the port 1433. All SQL traffic is routed to that port by the firewall.

any other info greatly appreciated

 

[DrSql]

Is your developers PC sits behind a router, if so it might get assigned diff IP. So why dont you get your local PC IP and ping from SQL Server.

Dr.Sql
Good Luck.

 

[freshegg]

the pc does not sit behind a router so it will be able to ping fine -

any more thoughts?

cheers

 

[freshegg]

Still stuck on this issue if anyone has any ideas

thanks

 

[Jomercat]

I connect to my SQL at work using VPN.

The VPN connection gets you inside your network.

1. Your VPN conection should be configured to access your public IP address of your router/firewall.

2. The Router/Firewall must be configured to allow VPN connections for the particular user.


Jose.

 

[freshegg]

my colleague connects to the web via NTL. His computer plugs into the back of the set top box and straight onto the net. No routers or other networking devices are in the way.

it is bizarre because it is not software, firewall or his network and i am scratching my head as to what else it might be

cheers