Hi guys,

I am having a problem with my installation. I have followed with, I believe, almost all of the different tutorials out there but am still stuck.

These are the steps that I took:

1. Download the "install" package from this website

2. Unzip it and put it in InetPub folder

3. Make a virtual drive for "DotNetNuke"

4. Created a database in SQL Server 2005 called "DotNetNuke"

5. Rename release.config to web.config

6. Edit the connection strings in web.config so that it would talk to SQL Server

7. Got to my browser and typed in "http://localhost/DotNetNuke/" and I got this message "Could not connect to database specified in connectionstrings for sqldataprovider"

I kept on getting that error message for several times. If anyone can help me with this problem, I would really appreciate it.

Heindy

It looks as thougth your connection string isn't using the correct id & password. Verify those are correct.

Since your server name is SQLEXPRESS, I surmise that you are in fact using SQLEXPRESS and NOT SQL2005.  So a simpler solution would be to use the SQL Server 2005 Express connection string:

<!-- Connection String for SQL Server 2005 Express -->
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2000/2005

That way you do NOT have to create anything in SQL Server management Studio Express.

I suspect though that when you created your DotNetNuke DB in Studion Express that you didn't physically locate it in the |DataDirectory but rather it is located in the MS SQL default directory and so the connection string is not directing the DNN to the correct location.  The DNN Database.mdf is located in the Website\App_Data directory