Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    5

    Unanswered: Push Subscription Connection Fails

    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?

  2. #2
    Join Date
    Jan 2003
    Posts
    5

    Smile

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •