Solved

Cisco Router remote login for SQL

Posted on 2012-03-26
6
424 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 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Deploying Windows application to Windows 10 using Group Policy ? 4 46
tempdb log keep growing 7 34
SQL create line numbers for data sampling 11 28
SQL Recursion 6 20
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…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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.

831 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