Hi folks,

I'm taking over the hosting of a DNN website for a client from a competitor. The competitor has provided me with a zip of all files from the root of their web site and an MS SQL backup of the database. Unfortunately I've not touched DNN before yesterday so I have no clue on the best way to migrate this.

So far I have:
* Installed a Win2003 Std server, Installed IIS and patched it up
* Installed SQL 2005 Std, client tools
* Created a new database and Restored the provided backup
* Created a user in the SQL server to match the username in the connection string

At this point I have the famous "assembly version does not match the database version" error. It says the login failed and "the password must be changed" but I suspect that's a misleading error message. Naturally I am unable to contact my competitor for advice on how to steal their business so I'd appreciate any advice you have on the best way to handle this migration. I do not know what SQL version they were running at the old site nor if there were any changes from the default.

[code]
   <!-- Connection String for SQL Server 2000/2005 -->
    <add name="SiteSqlServer" connectionString="Server=localhost;Database=username;uid=username;pwd=password;" providerName="System.Data.SqlClient" />
 

    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
    <add key="SiteSqlServer" value="Server=localhost;Database=username;uid=username;pwd=password;" />

Note: dbname and username are identical for convenience.
[/code]

Thanks in advance,
Sean