SQL Server Performance Forum – Threads Archive
Error while setting up publisher
Hi..One more error prompt by windows during setting up the Publisher.
Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option ‘publish’ of database ‘test’ has been set to false. I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help sp_dropserver "servername", droplogins
go
sp_addserver ‘servername’, local
hope this helpfull http://dbforumz.com/-Publishing-Database-error-ftopict53117.html http://www.technologyone.org/new-1520619-3730.html
Is this connected to other thread?
I hope not. In order to resolve the issue may check this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;302223 for further information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
It works.. thanks…
quote:Originally posted by motioneye
Hi..
One more error prompt by windows during setting up the Publisher.
Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option ‘publish’ of database ‘test’ has been set to false. I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help sp_dropserver "servername", droplogins
go
sp_addserver ‘servername’, local
One more error prompt by windows during setting up the Publisher.
Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option ‘publish’ of database ‘test’ has been set to false. I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help sp_dropserver "servername", droplogins
go
sp_addserver ‘servername’, local
quote:Originally posted by motioneye
Hi..
One more error prompt by windows during setting up the Publisher.
Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option ‘publish’ of database ‘test’ has been set to false. I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help sp_dropserver "servername", droplogins
go
sp_addserver ‘servername’, local
One more error prompt by windows during setting up the Publisher.
Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option ‘publish’ of database ‘test’ has been set to false. I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help sp_dropserver "servername", droplogins
go
sp_addserver ‘servername’, local
Always check the server name on all servers involved in replication before replication configuration to avoid this kind of issues…
SELECT @@SERVERNAME
Mohammed U.
Arka & Supnumb,
What was your question? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>