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 |
|
Rockn
Starting Member
10 Posts |
 Posted - 2002-04-05 : 11:40:33
|
| I am trying to transfer database objects from one SQL 6.5 server to another over the internet. We have a Checkpoint Firewall and I have opened port 1433 to a static remote IP address and the servers still cannot connect. I have tried to do a system ODBC connection and that fails as well. On the servers I have Named Pipes and TCP/IP set up for SQL connections. Am I missing some other port that needs to be opened? |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-04-05 : 11:52:31
|
| did you open 1433 both ways?setBasedIsTheTruepath<O> |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-05 : 11:57:55
|
| Did you set up an alias for your server, using Client Network Utility (and if you did, did you tell it to use TCP/IP)?---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
|
|
|
Rockn
Starting Member
10 Posts |
Posted - 2002-04-05 : 12:23:41
|
| Do you need an alias on the local server for it's name using TCP or just for each remote server? I have opened port 1433 on both sides of the connection. I have never created an alias before because we currently are only using the db locally using named pipes. I have also added TCP/IP in the SQL setup. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-05 : 13:31:55
|
| One thing I've found to have in your ODBC connection string is the port number, something like this:DSN=DSNName;UID=username;PWD=password;Network=DBMSSOCN;Address=ServerName,1433;The Network specifies the TCP/IP library DLL name, and the Address portion list the server's alias (or its IP address) AND the port number. I could never get ODBC connections to work without these settings.HTH |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-05 : 13:50:29
|
quote:
Do you need an alias on the local server for it's name using TCP or just for each remote server?
You should only need aliases for the remote servers... ---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
|
|
|
|
|
|
Enterprise Manager Connection