I have installed several versions on DNN over the years. I'm trying to install v06.01.04 on a new SQL 2008 SP 3 server under IIS 7.5. I can connect to the empty database with SQL Query Analyzer using integrated security just fine.
I have changed the connection string in the web config file to:<add name="SiteSqlServer" connectionString="Server=BCATV-EDIT-5-PC\SQL2008;Database=DNN6_BCATv;Integrated Security=SSPI;Persist Security Info=False;" providerName="System.Data.SqlClient" />.
When I run the install page, I immediatley get the following error:
The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database. You can continue to use either of the other two Wizard options and configure the Database settings at the appropriate Wizard step.
When I try to manually configure the database connection in the Configure Database Connection page to use integrated security, I get the following error:
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed
I have never had this type of trouble in the past. Any ideas? Thanks, Brad