I know there are many posts related to this problem, I tried all those tips but still could not solve my problem.

I am running window2003, with SQL 2005 on separate box. Trying to get dnn installed with installer.

Here is my connection string:

------------------------------------

<!-- Connection String for SQL Server 2000/2005 -->
    <add
      name="SiteSqlServer"
      connectionString="Server=SQL-01;Database=DNN;Integrated Security=SSPI;"
      providerName="System.Data.SqlClient" />

------------------------------------

I  tried to add "uid=xxx;pwd=xxx;" but still won't work.

The exact error shown as:

--------------------------------------------------------------------------

DotNetNuke Upgrade Error

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

ERROR: Could not connect to database.

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

-----------------------------------------------------------------------------------------

If I install SQL 2005 Express on the same box with IIS, then everything would be working without problem. But that's not what I want.

Please help! (my email: pzhang@pcsigroup.com)

Thanks.

It most likely created the version table and that is it. my advise is drop the db, re-create it, and start over. change your connection string back to include uid= and pwd=  then re-run the install and it should should run.

and assign the ASPNET user to the DNN directory and grant him full permissions.