I cannot get internet connection to work for push subscription to transactional publication.
Publisher/distributor: SQL Server 2000
Subscriber: SQL Server 2000
Connection: TCP/IP, SQL Authentication. Works fine from SQLEM or Query Analyzer.
Subscription: push, transactional, schema/data already initialized.
When I run distributor agent fails with "The process could not connect to subscriber 'TEST'", error "Server does not exist or access denied".
Agent output does not give anything more specific. It fails after...
Connecting to Subscriber 'TEST'
Connecting to Subscriber 'TEST.REPL'
Profiler shows nothing happening at all.
If change subscriber setup on distributor to use trusted connection instead of SQL Auth it works fine.
Any ideas?OK, so all the replication experts are on vacation this week but I eventually managed to figure it out myself.
When defining subscribers (through 'distributor properties') use the subscriber TCP/IP address directly and not a server alias like I was doing. Silly Billy!
Monday, March 26, 2012
Push Subscription Connection Fails
Labels:
2000subscriber,
connection,
database,
distributor,
fails,
internet,
microsoft,
mysql,
oracle,
publication,
publisher,
push,
server,
sql,
subscription,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment