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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Change of port number for Replication.

Author  Topic 

admin001
Posting Yak Master

166 Posts

Posted - 2002-07-05 : 03:31:40
Hello ,

How can i define a different TCP/IP port number , other than the default 1433; to replicate the database over a firewall on the source and the destination servers ? My source servers are SQL SERVER 7.0 with SP3 on Windows NT Server 4.0 and the destination servers are SQL 2000 with SP2 on Windows 2000 . Is it secured to use only the sa password for replication to the destination server ?

Where do i have to make changes in SQL server and Windows NT ? And further how secured it is to use this way for security ?

Any kind of assistance on this issue will be helpful to me .

Thanks in advance
Admin001

--------------------------------------------------------------------------------


   

- Advertisement -