Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Replication (2005)  error while trying to create a subscription

Author  Topic  abyie Starting Member 42 Posts Posted - 2007-01-19 : 10:55:03 Hi Guys, I am having issues while trying to replicate my database from server A to Server B in Sql Server 2005.Here is the message that I am getting. SQL Server could not create a subscription for Subscriber 'SALESFORCE2007'. ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The article '(null)' does not exist. Could not update the distribution database subscription table. The subscription status could not be changed. The subscription could not be created. The subscription could not be found. Changed database context to 'Main5'. Warning: The distribution agent job has been implicitly created and will run under the SQL Server Agent Service Account. Job 'NIGEL2006-Main5-nigeldata-SALESFORCE2007-10' started successfully. (Microsoft SQL Server, Error: 20027) Can Anybody help me on this? Your help would be greatly appreciated. Thanks ------- Abyie