Re: Replication to server with different Port
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Jax,
for a named instance, there is no default port - it is assigned at creation
from the list of available ports, and your port number won't necessarily be
the same as mine, for the first named instance. Usually the port number is
not specified in the replication definition, and it is dynamically picked up
(hence the slammer virus on UDP, port 1434 :)). Do you have 1434 blocked? If
not, then please try designing without the port number and see if this
works.
Also, The SQL Server Agent service (SQLServerAgent) at the client should not
use the LocalSystem account. It needs to use a standard domain account.
Finally, please check that the agents use impersonation.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
.
Relevant Pages
- Re: IIS, SQL 2000 & XPs Firewall
... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ...
(microsoft.public.sqlserver.connect) - Re: Do SqlServer 2000 & SqlServer 2005 co-exist
... Either SQL Server 2000 or SQL Server 2005. ... So you have to move one of them to another port. ... You could allow an program exception in your firewall instead of a port number exception. ... I understand that you can connect to SQL 2000 named instance on the local ...
(microsoft.public.sqlserver.setup) - Port Assignments : Multiple Instances : SSPI context issue
... A SQL server has the initial instance installed as a named instance ... Internet app is using 1433 to talk to the named instance. ... the install utility for the app does not work against ... By default it too is assigned port 1433!! ...
(microsoft.public.sqlserver.server) - TCP-Portnummern bei mehreren SQL Server Instanzen auf einem Computer
... wenn eine Firewall aktiv ist. ... the default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. ... Wenn man eine Anwendung schreibt die eine Named Instance verwendet, die man weitergeben möchte, ohne zu wissen welche SQL Server ...
(microsoft.public.de.sqlserver) - Re: Cannot see database engine behind a firewall
... Is it a named instance or the default instance? ... open UDP port 1434. ... Rick Byham, SQL Server Books Online ...
(microsoft.public.sqlserver.connect) |
|
