Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to be able to run SQLSMS and select an instance to connect to but the instances are on different networks. I remotely log on to our server and from there, I want to be able to access our clients servers on different networks.

I currently move data from our client server to our server to process over an ftp connection which takes time. Things would be significantly faster if I could log on to our server and have all the data already there and accessible essentially removing ftp.

I want to know if this is possible and if so, where can I look or go to accomplish this.

share|improve this question
    
Is VPN'ing an option for you? –  Thomas Stringer Mar 23 '12 at 20:09
    
Yes it is @Shark. –  Don Mar 23 '12 at 20:27

2 Answers 2

If you can access the instances at the IP layer then you will always be able to connect using either SQL Authentication (if enabled) and even Windows Authentication using the runas /netonly trick. Say you are in the domain 'foo' and you want to connect to an instance in the domain 'bar', and there is no trust relationship between 'foo' and 'bar'. Since the instance in the 'bar' domain can only authenticate an user in the 'bar' domain you would normally have to be running as 'bar\user' to connect to this instance, but of course your host in 'foo' will not let you run as 'bar\user'. runas /netonly to the rescue: start your client process (eg. SSMS) using the /netonly option:

runas /netonly bar\user "c:\program files\...\ssms.exe"

When launched this way (you'll be prompted for bar\user password) the SSMS will authenticate to any resource over the network as 'bar\user' and you'll succeed to connect to the 'bar' based SQL Server instance. This trick works with local accounts as well, so instead of bar\user you can use <machinename>\Administrator to appear to that machine as the local administrator.

If the destination server is unreachable at the IP layer then you have no option, you must make it reachable, either by VPN, or by DirectAccess, even a netcat bridge can work with the /netonly trick.

share|improve this answer

I hope I am understanding you question correctly, To be able to connect to sql server instance of different network you will need to consider following things, 1) Windows authentication will not work since both machines (SSMS and instance) are in different domains 2) Firewall rule has to be created to allow communication on ports 1433 (TCP) and 1434 (UDP) (default) on instance machine

And then you can connect using SSMS like below,

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.