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
 Development Tools
 ASP.NET
 Could not load Microsoft.SqlServer.Smo

Author  Topic 

davidinnz
Starting Member

1 Post

Posted - 2009-08-23 : 22:08:13
I am testing the deployment of a C# app that uses SMO. It was developed on a PC with SQL 2008.

When testing on a clean VM with .NET 3.5 SP1, but no SQL components, the app fails with the error:

quote:
Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.


Having hunted for a day already for a solution, I have tried pre-installing several MSI from http://www.microsoft.com/downloads/details.aspx?FamilyID=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en#ADOMD.NET
* msxml6_x86.msi
* sqlncli.msi
* SQLSysClrTypes.msi
* SharedManagementObjects.msi

This did not fix the problem. It did however, install a bunch of v10 DLLs into C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies on the VM. That is the same path as the References use in my .csproj file back on the dev machine.

Is there a solution to this? (Why is the error occurring, when nothing in the code appears to be looking for v9.x? Only v10.x.)
   

- Advertisement -