Solved

Cisco Router remote login for SQL

Posted on 2012-03-26
6
420 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:Leo
  • 3
  • 2
6 Comments
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 37774927
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
 
LVL 8

Author Comment

by:Leo
ID: 37775004
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
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 37775008
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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 
LVL 20

Expert Comment

by:agonza07
ID: 37778119
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
 
LVL 8

Accepted Solution

by:
Leo earned 0 total points
ID: 37908920
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
 
LVL 8

Author Closing Comment

by:Leo
ID: 37928242
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

Featured Post

Do email signature updates give you a headache?

Constantly trying to correctly format email signatures? Spending all of your time at every user’s desk to make updates? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SSL is a very common protocol used these days when browsing the web.  The purpose is to provide security to communication, but how does it do it?  There are several pieces at work that have to be setup before SSL will even work and it requires both …
Know what services you can and cannot, should and should not combine on your server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now