hii  Everyone,

My current erroe is:

DotNetNuke Upgrade Error

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

ERROR: Could not connect to database.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Same here.  I’ve tried connecting to both SQL Server 2000 and 2005 with no luck.  Not doing anything fancy/special other than connecting to our SQL Server rather than localhost.

Ok, I think I have what many of you have been looking for.  It at least worked for me.

This will work for those who are running a full version of SQL Server instead of SQLExpress.

Basically, what you need to do is uncomment the two sections of code for SQL and comment out SQLExpress.  The easiest way to do this is to replace the section of code between <connectionStrings> and <add key="InstallTemplate" value="DotNetNuke.install.config" /> with the following section of code replacing your servername, DBName, UserID, and Password with the generic names in the code.

    <!-- Connection String for SQL Server 2005 Express
    <add
      name="SiteSqlServer"
      connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
      providerName="System.Data.SqlClient" /> -->
    <!-- Connection String for SQL Server 2000/2005 -->
    <add name="SiteSqlServer" connectionString="Server=servername;Database=DBName;uid=UserID;pwd=Password;" providerName="System.Data.SqlClient" />
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/> -->
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
    <add key="SiteSqlServer" value="Server=servername;Database=DBName;uid=UserID;pwd=Password;" />

It’s a really simple thing, I know, but this had us scratching our heads for quite awhile.  Hopefully this is the answer to your problem.