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 |
|
elektrobank
Starting Member
15 Posts |
 Posted - 2003-03-24 : 17:12:13
|
| How do I connect to Sql Server remotely over the Internet? I have tried to simply enter the IP address of the computer I am trying to connect to into the server field of the Query Analyzer but that didn't work. I have also made sure the remote machine is not blocking the SQL port. How exactly can I get this working?Thanks... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-24 : 17:14:12
|
| Well in your connection string, did you pass the port also? I would hope that you aren't using 1433 since you are accessing it over the internet. So if you aren't, then just add the port to your connection string or create an alias using the Client Network Utility.Tara |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-03-24 : 17:38:09
|
| In query analyzer, under tools-->options.Click the Connections tab. Change the Login Timeout to about 60 seconds or so. I've noticed that sometimes it takes a long time to connect "over the internet."Just a word of caution: Having your SQL server on an IP where everyone can hit it is VERY dangerous. I'd almost say you should NEVER do this. Be sure to keep it patched as well as have very strong passwords for all of the accounts.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Remote connetion