Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    15

    Unanswered: Replication Pull subscription problem

    Iam trying to pull subscription and Iam getting same error over and over again. The error says:

    ****SQL Server Enterprise Merger could not create a pull subscription to publication "database name"
    Error 15004: Name cannot be null *****

    Thanks

  2. #2
    Join Date
    Feb 2005
    Location
    Australia
    Posts
    1

    Thumbs up

    Hi

    Its because of non-existence or invalid server info on sysservers table. Please follow the instructions to fix the above problem.

    exec sp_dropserver <your_local_server_name> -- subscriber

    exec sp_dropserver <remote_server_name> -- publisher

    exec sp_addserver <your_local_server_name>,local

    exec sp_addserver <remote_server_name>

    shutdown -- it is mandatory to take effect otherwise you still get the same error
    go

    Start the sql server with SQLSERVERAGENT

    exec sp_helpserver -- it should display your local server and publisher

    Then, try configure pull subscription

    Cheers
    Sekar
    Last edited by k_sekar; 02-01-05 at 19:33.

  3. #3
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    What version does this happen in? I thought Microsoft fixed this problem a while ago.

Posting Permissions

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