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 |
|
MarkE
Starting Member
1 Post |
 Posted - 2004-06-24 : 08:50:46
|
| I am trying to connect to my SQL server over the net. The SQL server (2000 SP3a) is running on a dedicated server (OS W2K) using instances.On teh local machine, I can use enterpise manager to generate a new connection xxx.xxx.xxx.xxx\instance and this works OK, but when I try to use Enterprise manager on an external machine to do the same, the remote machine fails to connect. SQL Server is using the default port of 1433, and TCP/IP is selected as an enables protocol in Network managerCan anyone suggest waht might be the problem, and what I can do to fix it?Thanks in advanceMark |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-24 : 12:28:35
|
| Can you ping the database server from the external machine? What is the error that you are getting?Tara |
 |
|
|
|
|
|
Connection to SQL over IP