Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mssqlservertutorial
Starting Member
1 Post |
 Posted - 2011-06-01 : 23:11:05
|
| Hello,I have 2 dedicated servers with a hosting company. I don't think they are under same domain so I guess I have to access sql server on one machine from the other through internet.I have successfully enabled remote access with fixed IP XXXX (Added XXXX to Firewall) and I can connect successfully by typingSQLCMD -E -S MySQLServerMachine\SQLEXPRESS,XXXXbut on the same machine.How can I do that from the other machine ? I read on MSDN that I need to forward port but I don't know how to do this (can't find a real tut) and would it be enough ? Afterwards how would I reference this sql server: Would IP:xxxx OK ? Thanks, |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-06-02 : 10:45:15
|
| try setting up a DSN on the server you want to connect from, the "Test Connection" button should tell you if firewall settings etc are correct. |
 |
|
|
|
|
|
I have enabled remote access how do I connect ?