November 18, 2010 at 6:44 am
I am trying to set up replciation in SQL 2000. I get the error below. I have tried to install the components for replication, but I cannot find a place in the wizrd that does it. Any help you be appriciated
TITLE: New Publication Wizard
------------------------------
Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.
------------------------------
ADDITIONAL INFORMATION:
Cannot load the DLL xp_regenumvalues.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Replication components are not installed on this server. Run SQL Server Setup again and select the option to install replication. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2040&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
November 18, 2010 at 6:50 am
v2000 umm...
Have you tried running sql server setup and see if there is an option to add replication to an isnatnce?
Cursors never.
DTS - only when needed and never to control.
November 18, 2010 at 7:20 am
That was the first thing I did. I managed to fix it by dropping and readding the XP that was failing. Now I get
This database is not enabled for publication.
SQL 2000 is awesome!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply