Tag Archive | "database publish"

Tags:

Database Publishing Wizard error message


When you try to publish your local database to remote server using database publish wizard you might get following error:

This wizard will close because it encountered the following error: 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Database+Publishing+Wizard&ProdVer=1.1.1.0&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

ADDITIONAL INFORMATION: 

Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo

Screenshot as following:

Mostly it’s because it cannot load the assembly of SMO (SQL Server 2005 Management Objects).

If so, you can try to download it from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en (Section: Microsoft SQL Server 2005 Management Objects Collection ).

For more information, you can refer to Database Publishing Wizard documentation (http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=DPW%20Documentation&referringTitle=Database%20Publishing%20Wizard).

Share

Posted in SQL ServerComments (0)