DotNetNuke Upgrade Error

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.

This is killing me. I've tried to install DNN 4.34 repeatedly on my main weserver and I keep getting this error. I've also been through all the help I can find. The biggest unusaul thing on this machine is that it is a domain controler, I know thats its not a good idea but thats where I am. It looks like a security issue but I can nail it down. I have tried debuging to no avail. From my App Event log here's what I see:

bump..

No answers on this? Anyone else have DNN working, not woking on a domain controler?

I was getting exactly the same error message, then also an error that the connection string was incorrect.

It took me a while to realise what my problem was.

In the web.confing file I used the following to get it working

<add key="SiteSqlServer" value="Server=servername.domainname.co.uk;Database=dnn;uid=sa;pwd=password;" />

<add name="SiteSqlServer" connectionString="Server=servername.domainname.co.uk;Database=dnn;uid=sa;pwd=password;" providerName="System.Data.SqlClient" />

The problem was that I replaced Server=(local) with Server=(servername).  So when I removed the brackets and specific the hostname it worked!  A silly simple error, but one which I think could be added to the comments of the web.config file. 

It should work fine with just the hostname instead of the fully qualified domain name, and don't use the sa, I used that whilst trying to work out what was going wrong.  I also tried deleting and recreating the database too.

I hope this helps other people.