Is ptrusty's method of setting up the connectionstring for SQL 2000/2005 the proper/authorized way to go?  It seems that this way of connecting to SQL 2000/2005 would have been explained in the Installation Guide.

After having the Subject error, I did set my web.config up by exposing SQL 2000/2005 and commenting out SQL Express.  DNN deployed successfully, but all of my core modules show this error:  DotNetNuke.Services.Exceptions.ModuleLoadException: An error has occurred while establishing a connection to the server. 

The error message makes me wonder about my database connection, although everything else is working.

Can anybody give me a clue as to what is wrong?

Thanks,

Ken

Thanks Charles,

This regards setting up the connection strings for SQL 2000/2005.  Setting up the connection strings requires close inspection and attention to detail.  What I found is that not only do we have to insert our specific connection string information it two places, but we also must place comments around SQL Express in two places AND remove the comments around SQL 2000/2005 in two places.  What I hadn't noticed is that I had to add and remove comments.

Ken

I am getting the same error and figure out where I am going wrong:

Could not find file 'C:\Sites\Single28\chrisbarber1\webroot\Providers\DataProviders\SqlDataProvider\DotNetNuke_template.mdf'.

<connectionStrings>

<!-- Connection String for SQL Server 2005 Express -->

<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=c:\sites\Single28\chrisbarber1\webroot\App_Data\Database.mdb;" 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=c:\sites\Single28\chrisbarber1\webroot\App_Data\Database.mdb;" />

Can anyone help please?