Unable to configure distribution on SQL 2008

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

SQL Server Administration (2008)

Unable to configure distribution on SQL 2008

Author

Topic

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2011-07-11 : 06:49:44

I have a server which has 3 instances of SQL Server. 2 of them are SQL 2005, 1 of them is SQL Server 2008. All of them are Enterprise Edition 64 bit.

I am trying to make the 2008 instance a distributor in a replication set up. However I get the following error message when I launch the configure distribution wizard:

Server\Instance cannot be configured for publishing and distribution. Publishing and distribution are supported only in SQL Server version 7.0 or later

However I have no problems configuring distribution on the 2005 instances. What could be cauing this issue?

Sachin.Nand

2937 Posts

Posted - 2011-07-11 : 07:02:12

I think you cannot set up a distributor of a version greater than subscriber and publisher.

PBUH