Hi Guys,

I know that is is an old topic, but the net does not seem to come up with an easy solution. After playing around for a bit I managed to fix it, here is the soltion:-

After ensuring that "SELECT @@SERVERNAME" is NOT NULL ensure that the '[MSdistributiondbs]' and '[MSdistpublishers] ' tables are NOT present in the msdb database. If the are remove then and use the code below to add them back. Once this is done the "Error 208:..." will disappear and you can proceed in setting up your replication.

Good Luck 😀

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

) ON [PRIMARY]

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

) ON [PRIMARY]

GO