Error running the Distribution Wizard

I have a very strange error (included at the end of message) and it seems to indicate that I have not installed the SQL Server correctly - perhaps the wrong version. I have re-run the configuration a couple of times with no effect. I have not removed the server and re-installed yet. I have Here is my version info:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

TITLE: Microsoft SQL Server Management Studio

Could not start the wizard.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ConfigureDistWizard, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

You did not install replication support.|||When I run setup and attempt to change installed components the Microsoft SQL Server 2005 Setup dialog shows under Database Services the Replication option as already installed on the drive - I have uninstalled it and re-installed it with no effect. Are you talking about a different option that appears if I start from a fresh install? I am hesitating to uninstall SQL completely and re-install it as the database is being used and I would prefer to update it if possible.

Thanks for the answer.
|||

Hi Brian,

If you check directory D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE, could you find configuredistwizard.dll? And is this directory in your PATH environment variables?

Peng

|||Hi Peng,

No I don't haveconfiguredistwizard.dll in my P:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE directory, but I do have the CreatePubWizard.dll in there. That directory is in the path.

Brian
|||

It is very strange. What is your upgrade sequence? 2005 RTM->SP2 or 2005 RTM->SP1->SP2? Does your machine use AMD64 processor?

One way to help troubleshoot the problem is to search in files under directory C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files and look for ConfigureDistwizard.dll. See if there are any error messages.

Also post your question in the SQL setup forum. There might be some experts that can give you better advice.

Peng

|||Hi Peng,

I'm not sure about the installation sequence because I did not install it myself. I eventually uninstalled the SQL Server Database Engine completely and re-installed fully and now the wizard appears.

Thanks again,
Brian