Solved

Cisco Router remote login for SQL

Posted on 2012-03-26
6
426 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 80

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 80

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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

This is the first one of a series of articles I’ll be writing to address technical issues that are always referred to as network problems. The network boundaries have changed, therefore having an understanding of how each piece in the network  puzzl…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

697 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