Ok. in your web.config there are connections strings in 2 places, the connectionStrings and appSettings sections. In each section, there are 2 connections strings, 1 for SQL Server and 1 for SQL Server Express. By default, the entries for SQL Server are commented out and the 2 strings for SQL Express are active. If you are using SQL Server, you need to comment out the 2 entries for SQL Express and un-comment the 2 entries for SQL Server, then modify the connection string values for BOTH SQL Server connection strings.
In the following example, I have commented out the SQL Express entries (lines 2 thru 7 and 16 thru 21) and un-comments the entries for SQL Server (lines 10 thru 12 and 25 thru 26. I would then need to modify the connections strings to contain the correct database name, user id and password in BOTH connection strings, lines 11 and 26.
I hope this makes it clearer. The second connection string is for use with Legacy modules for backward compatibility, which means modules built prior to the release of DNN 4.x which changed the location of the connection string in the web.config.
1: <connectionStrings>
2: <!-- Connection String for SQL Server 2005 Express
3: <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;
4: Integrated Security=True;User Instance=True;
5: AttachDBFilename=|DataDirectory|Database.mdf;"
6: providerName="System.Data.SqlClient" />
7: -->
8:
9: <!-- Connection String for SQL Server 2000/2005 -->
10: <add name="SiteSqlServer" connectionString="Server=(local);
11: Database=DotNetNuke;uid=****;pwd=****;"
12: providerName="System.Data.SqlClient"/>
13: </connectionStrings>
14:
15: <appSettings>
16: <!-- Connection String for SQL Server 2005 Express - kept for backwards
17: compatability - legacy modules
18: <add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated
19: Security=True;User Instance=True;
20: AttachDBFilename=|DataDirectory|Database.mdf;" />
21: -->
22:
23: <!-- Connection String for SQL Server 2000/2005 - kept for backwards
24: compatability - legacy modules -->
25: <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;
26: uid=****;pwd=****;"/>