Hi Guys,

I have been struggling, trying everything I can think of to get my connection string working with sqlserver 2005. This is the message I get:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I also get:

Error Installing DotNetNuke

Current Assembly Version: 04.04.01

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

This is my  connection string:

<connectionStrings>

<add
      name="SiteSqlServer"
      connectionString="Server=(localhost);Database=paul;uid=sa;pwd=new_password;"
      providerName="System.Data.SqlClient" />  
</connectionStrings>

'paul' is the name of the database i created in sqlserver 2005

'sa' and 'new_password' are the U and P that I log into sqlserver with the Authentication mode of: SQL SERVER AUTHENTICATION

Do I need to make a user and password under the paul->Security->Users, if so how do I do that?

    - When I try add the sa user i get a message:  Can not use the special principle 'sa'

I would really appreciate any help. I can't think of what else to try. If you need any more information, just ask, Thanks!