Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    76

    Unanswered: Error 15004 Name cannot be null

    I made a publisher for marge replication via ISDN Dialup connected server and registered server x to y and y to x with TCP/IP.

    I can see both data on each other.

    I publish one database and try to configure pull subscription on 2nd one got following error.


    SQL Server enterprise manager could not create a pull asubscription to publication pmst

    Error 15004 Name cannot be null


    Thanks to all of you

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You've got a relatively unusual configuration for replication. I don't know of anywhere to look for specific details to help you, but I've got some ideas.

    I'd start by synchronizing the clocks on both servers, preferably to a common time source or better yet synch one machine's clock to the other's clock. Open a copy of SQL Profiler on both machines and trace with no filtering (so you can see every command executed against the server). Try to re-subscribe again. The last command in each profile is suspect, the one with the later timestamp is likely to be the source of your problem.

    You are probably looking for an empty string or NULL string parameter. Once you find it, you'll have to post what you find and maybe one of us can help you.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Do "SELECT @@SERVERNAME" on both servers.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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