Post reply

Error: 14010 Severity: 16

  • May 24, 2005 at 11:46 pm

    #86405

    OK, I'm a newbie at replication, but I've been doing some testing and getting a strange error and am scratching my head on this one.  I'm working with two scenarios.  One is a personal test environment where two servers are connected with my windows authentication.  The second is a shared test environment where two servers are connected across domains.  I can get to one of those servers with my windows authority and I am connected to the other server using a SQL account.  I've successfully done a transaction replication in both of these environments.  I'm now trying to do merger replication and it works fine in my personal environment and blows up in the SQL connection.

    Last command: {call sp_MSgetreplicainfo(?,?,?,?,?,?,?)}

    Error: 14010 Severity: 16 Description: The remote server is not defined as a subscription server.

    It takes me an hour to set up the snapshot and almost an hour to transfer the data in both systems.  Why is it transfering all the data and schema and THEN figuring out it's not a subscription server?  Looking at the publication configuration, it looks to me like it is a subscription server.

  • May 25, 2005 at 10:39 am

    #561024

    I wake up this morning and I still don't get it.  Then ding! Light bulb time.  I asked it to check to make sure the subscriber can do insert/update/delete, but didn't set up the permissions for it to do so.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply