Hi folks

I'm attempting a side by side upgrade of SQL 2005 to SQL 2008. As you probably know, this involves a parallel install of an instance of SQL 2008 alongside the original SQL 2005 instance. All seems to be OK on the SQL side of things, and the DNN database has successfully been detached from 2005 and reattached to 2008, also the DNN account has been successfully transfered from the 2005 instance to the 2008 instance.

Unfortunately, DNN 5 still doesn't seem to be able to see the database in the new instance - the DNN admin page for example, just defaults to the 'Under Construction' message page. I have a feeling it may be an incorrect connection string syntax, this is what I have tried at the moment, which appears to be unsuccessful (names changed to protect the guilty):

connectionString=
     "Data Source=MyComputerName\MyNewSQL2008InstanceName;
     Initial Catalog=MyDNNDatabaseName;
     User ID=MyDNNDatabaseAccount;
     Password=MyDNNDatabaseAccountPassword"
     providerName="System.Data.SqlClient"/>

I think perhaps the instance syntax is wrong, but it's not the default instance that DNN should be connecting to anymore, so how should I include the new instance name in the DataSource attribute?

Thanks for any advice.

Cheers