This is my third install of DNN and I thought I had it down, but I am getting a DB connection error.

 Error Installing DotNetNuke

Current Assembly Version: 04.03.05

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

_________________________________________________________________________________

Here are my web.config settings:

<connectionStrings>

<!-- Connection String for SQL Server 2005 Express

providerName="System.Data.SqlClient" />-->

<!-- Connection String for SQL Server 2000/2005-->

<add name="SiteSqlServer" connectionString="Data Source=CAROLANDROB;Database=DotNetNuke;uid=TestUser;pwd=P@ssword1" 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="Data Source=CAROLANDROB;Database=DotNetNuke;uid=TestUser;pwd=P@ssword1"/>

__________________________________________________________________________

I tested the connection string using the server manager and it is fine there. I even copied the connection string from the properties of the server manager into the web.config with no success. This is driving me crazy.

The only difference between the installations that I have done are:

1. This one is on my home machine and hitting the local copy of SQL Server(CAROLANDROB) instead of a remote development server at work.

 2. This install is using version 4.3.5 instead of  using version 4.0.3

LITTLE HELP?!

Thanks,

Rob

Try this

name="SiteSqlServer"

connectionString="Server=(local);Database=XXXXXX;uid=yyyy;pwd=zzzzzzz;"

providerName="System.Data.SqlClient"

and

sk,

I had tried it with and without the ; at the end of the connection string,

TestUser is my only user in the DotNetNuke database,

and the connection exists in visual studio. I changed the server to "Server=(local) and that has changed my error to:

DotNetNuke Upgrade Error

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

ERROR: Could not connect to database.

Login failed for user 'CAROLANDROB\ASPNET'.

I have also tried using integrated security just for something to do.

Still no luck. There must be a single magical combination that will unlock the mystery of the connection string.