Friday, March 30, 2012

New to replication please help

Hi

I am new to this topic.i am trying to create a publisher in sql server 2005

here is what i do..

sql server studio->replication->local publisher->New publication

I get this error mesage

"Microsoft sql server management studio is unable to access replication components because replication is not installed on this instance of sql server

Additional information:Execute permission denied on object sp_MS_replication_installed database:master,owner:dbo"

I have installed sql server again but it show me the same error.

please anyone let me know.

To install here are the steps which i followed.

To install replication components, including Replication Management Objects (RMO), select SQL Server Database Services on the Components to Install page of the Installation Wizard.
To install replication components:

On the Components to Install page of the SQL Server Installation Wizard, click Advanced.

On the Feature Selection page, expand Database Services.

Click Replication, and then click Entire feature will be installed on local hard drive.


After this a screen pops up saying Database Services on the Components installed.

there is a button at the bottom called details when clicked shows up with the message below.

Name: Microsoft SQL Server 2000
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Service pack requirement check:
Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.


I have no idea what does this message means.

please let me know

|||It means you're trying to upgrade, but cannot due to requriements that you haven't met. Read the books online topics for more information.

No comments:

Post a Comment