You are here:Home » tsql » SQL Server is unable to complete the New Publication Wizard - Replication Error

SQL Server is unable to complete the New Publication Wizard - Replication Error

The last time we saw the issue we faced during setup of replication and it was due to original server name change. We came out from one issue But today I am writing for another issue which I faced in the same for replication configuration. I think this is something bad happen during workaround for the solution earlier, by mistake, something went wrong while old server drop and it were used in replication. Even we will look for the solution for this too. So let us move on the error which I get on initial stage of replication configuration while adding publication using Publication Wizard,
“TITLE: New Publication Wizard
------------------------------
SQL Server is unable to complete the New Publication Wizard.

------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Invalid object name 'msdb.dbo.MSdistributiondbs'. (Microsoft SQL Server, Error: 208)”
It seems these objects getting destroyed while workaround for earlier error. Finally, I got solution online as how to create those objects in msdb database,
USE MSDB
GO

CREATE TABLE [MSdistributiondbs] (
 [name] [sysname] NOT NULL 
 ,[min_distretention] [int] NOT NULL
 ,[max_distretention] [int] NOT NULL
 ,[history_retention] [int] NOT NULL
) 
GO

CREATE TABLE [dbo].[MSdistpublishers] (
 [name] [sysname] NOT NULL 
 ,[distribution_db] [sysname] NOT NULL 
 ,[working_directory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
 ,[security_mode] [int] NOT NULL 
 ,[login] [sysname] NOT NULL 
 ,[password] [nvarchar] (524) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
 ,[active] [bit] NOT NULL 
 ,[trusted] [bit] NOT NULL 
 ,[thirdparty_flag] [bit] NOT NULL 
) 
GO
Above objects created and finally I was succeeding to go ahead for my next steps!