Cisco Router remote login for SQL

I have a staff who access SQL server 2008 r2 database by logging on to SQL server and then connecting to a database which is hosted at an external site, so when he connects to the database it connects to an external IP address of 111.67.x.x, and our internal IP address range is in 172.16.x.x.
Now when he tries to connect to the same database from his own machine, it doesnt let him log in by using the same server details.
i have logged on to router but i cant see any entry for this machine or for the SQL server....
On the SQL server when i do netstat i can see his computer Ip address connected via 1433....
so what should i do :-)

Thanks.
LVL 8
LeoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
I'm confused.  Where can he connect remotely to this database, and where can he not connect to this database?

Is the database setup for tcpip access? Default setting is NO.  Is the remote site allowing port 1433 access and is it forwarded to the right machine? And is the remote machine firewall setup to allow port 1433 access?
0
LeoAuthor Commented:
If the user logs on to SQL server he can access the database, if the user tries to access the database from his machine, he cant access it...
the way the database has been setup, i am not sure about it, kindly let me know what to check?
i have checked on cisco router firewall, i didnt find any rule on that machine or SQL server or for port 1433...
0
David Johnson, CD, MVPOwnerCommented:
If the user logs on to SQL server he can access the database, WHERE IS HE WHEN HE CAN ACCESS IT? if the user tries to access the database from his machine, he cant access it...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

agonza07Commented:
Are there any rules for the SQL Server at all? If that Server has a 1to1 Nat translation, it could be that the other side (111.67.X.X) is only accepting incoming connections from that server.
0
LeoAuthor Commented:
The solution was on cisco router the ip address for that machine was changed, because all the computers get there IP addresses through DHCP, so the client restarted the machine, and the new IP address didnt had the rule in the router config.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LeoAuthor Commented:
The solution was on cisco router the ip address for that machine was changed, because all the computers get there IP addresses through DHCP, so the client restarted the machine, and the new IP address didnt had the rule in the router config.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.