Hi

after a lot of efforts I've moved databases with master, msdb to new server and execute replication configuration script which I was generated in old server but the 'Local subscriptions' is empty whereas 'Local Publications' exists!

Also when I launch replication monitor and click on each publication, all it's subscriptions have 'Unintialized subscription' status. Should I reinitialize all subscriptions for each publication (or something else solution) to accomplish my task?

does something wrong ?

thanks in a

It seems there is an error in your replication setup scripts.

I suspect the error is in the call to sp_addpushsubscription_agent (if it is push subscription) or sp_addpullsubscription_agent (if it is pull subscription). Specifically the @publication parameter is wrong as the Distribution Agent is stating that the specified Publication " does not exist.

http://stackoverflow.com/questions/11121652/uninitialized-subscription-error-in-replication-monitor

https://social.msdn.microsoft.com/forums/sqlserver/en-US/c7148997-6b2b-4b25-9fa0-965ab4b9eb07/uninitialized-subscription-error

• Edited by Dinesh Vishe 4 hours 34 minutes ago

Thanks for reply

As I found out with your links, This problem more likely related to permission issue, but I don't know how to solve this problem and what script (or operation) should I perform to work-around this problem.

thanks in advance