Error 14114 when creating publication

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 2000 Forums

Import/Export (DTS) and Replication (2000)

Error 14114 when creating publication

Author

Topic

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2003-12-08 : 16:56:27

I get the following error:

****************
Sql Server Enterprise Manager could not configure "MyServer" as the distributor for "MyServer"

Error 14114: '(null)' is not configured as a distributor
****************

This occurs during the first step of creating a publication via EM: Configuring Distributor.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-08 : 16:59:55

Did you create the distributor first? Go to the distributor server, right click on it in EM, then go to properties. Now click on the tab that says replication. Then click configure.

Tara

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2003-12-09 : 09:23:30

Yes, I get the same error there. It just happens on this one machine. I was able to setup another server as a distributor without a problem.

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2003-12-09 : 09:37:34

Run SELECT @@SERVERNAME on your publisher and distributor. Make sure the command returns the correct server names. If not, you will have run sp_dropserver and sp_addserver with local parameter.

--
HTH,
Vyas
http://vyaskn.tripod.com

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2003-12-09 : 14:16:49

That's the problem because it is coming back NULL. However,

sp_dropserver 'KTB-OPTIPLEX'
sp_addserver 'KTB-OPTIPLEX'
select @@SERVERNAME

does not resolve the problem. Any suggestions?

Thanks

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2003-12-09 : 15:00:46

You missed the 'local' parameter in sp_addserver. See BOL for more info, but here's a quick example:

EXEC sp_addserver 'KTB-OPTIPLEX', 'local'
GO

--
HTH,
Vyas
http://vyaskn.tripod.com

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2003-12-09 : 15:17:47

exec sp_dropserver 'KTB-OPTIPLEX'
GO
exec sp_addserver 'KTB-OPTIPLEX','local'
GO
SELECT @@SERVERNAME
GO

Still shows Null. No Errors. If I don't do the sp_dropserver first I do get an error stating that it already exists.

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2003-12-09 : 15:22:50

Okay, forgot to mention. Restart SQL Service. This is mentioned in BOL too.

--
HTH,
Vyas
http://vyaskn.tripod.com

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2003-12-09 : 15:49:09

As my 2 year-old would say, oh jeeesh.

Thanks. That solved the problem.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources