Solved

Cisco Router remote login for SQL

Posted on 2012-03-26
6
422 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 79

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 79

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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

776 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