I'm exploring the option of using DotNetNuke for a portion of my company's website, but have been unable to get it to install.

I'm trying to install it on my local machine (Windows XP Professional/IIS 5.1, with SQL Server 2005). 

When I try the Auto install, I get the following message:

Error Installing DotNetNuke

Current Assembly Version: 04.07.00

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

When I try typical or custom install, it can connect to the database just fine (the connection test passes), but when it goes to run the scripts, I get the following:

"Installing Database- Version 4.4.0...undeinfed...Success"

Clicking next simply repeats the step, with the same result.

The {Server}\ASPNET account has the appropriate permissions for the website, and I believe it has the appropriate permissions for the database as well (I specified Trusted_Connection = True in the connection string).

Any suggestions on where to look next?  Thanks.

Tim

    Target:

    Is SQL Server 2005 running on another machine or is it Express running on yours???

    If it is Express running on your PC, there is no need to change anything in the connect string.  This has been very confusing for people installing DNN, especially those with some knowledge of SQL Server 2000, or even 2005 Server but not the express version.  SQL 2005 Express introduced the concept of "User Instance", which allows developers (like the developers of DNN) to distribute the application database a la XCopy mode that you can do with the ASP.Net code.  In other words, you don't need to attach the DB file before using it.  This has some limitations, like the DB is not readily visible in the Express DB Manager, but DNN will actually run and be able to use the database.

    See this thread where I explain more details about the "User Instances" and a reference to an article in MSDN.

            Carlos

I too am receiving the same error when installing the database.  I have a blank database setup in SQL Server 2005.  I have changed the connection string in two places in the web.config file.  When I test the connection within the install wizard it connects perfectly but I when I proceed to the next screen I get this error:

Installing Database - Version 4.4.0...undefined...Success
Installation of Database Complete

 <add name="SiteSqlServer" connectionString="Data Source=MYSERVER;Initial Catalog=MYDB;User ID=MYUID;Password=MYPWD" providerName="System.Data.SqlClient" />

<add key="SiteSqlServer" value="Data Source=MYSERVER;Initial Catalog=MYDB;User ID=MYUID;Password=MYPWD" /> 

Any ideas or thoughts would be great!

OS=Server 2003 R2
SQL Server 2005
DNN 4.7.0