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 *****
ThanksHi
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|||What version does this happen in? I thought Microsoft fixed this problem a while ago.
Friday, March 23, 2012
Replication Pull subscription problem
Labels:
create,
database,
enterprise,
error,
iam,
merger,
microsoft,
mysql,
oracle,
pull,
replication,
sayssql,
server,
sql,
subscription
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment