« Previous Next »

• 05-01-2009, 7:01 PM

  jonpauldavies Joined on 03-18-2009, 1:08 PM Posts 3

  Deploy to Sql Server 2005 Express - msdeploy, dbfullsql, SMO error Reply Contact I'm trying hard to get a working package but failing hard. I'm trying to test deployment using msdeploy.exe to sql server 2005 express but I'm getting this error. Action: Adding dbFullSql (install.sql) Error:  Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Ver sion=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its d ependencies. The system cannot find the file specified. Error count: 1  This seems to imply that I need SQL Server 2008 SMO installed in order to get it to work. I dont want SQL 2008 installed, I need it to work with 2005. I think this part of my manifest.xml is causing the issue as dbfullsql seems to require SMO 2008     <parameter       name="Connection String"       description="Automatically sets the connection string for the connection request."       defaultValue="Server={Database Server};Database={Database Name};uid={Database Administrator};Pwd={Database Administrator Password};"       tags="Hidden">         <parameterEntry           type="ProviderPath"           scope="dbfullsql"           match="install.sql" />     </parameter> Any ideas on how to get this working?

• 05-02-2009, 5:43 PM

  In reply to

  jonpauldavies Joined on 03-18-2009, 1:08 PM Posts 3	Re: Deploy to Sql Server 2005 Express - msdeploy, dbfullsql, SMO error Reply Contact its ok, forget it. i worked out that there is no getting around these dependancies by looking at the umbraco installer.