I am trying to port a working DNN site from a 32 bit machine to a 64 bit machine both running Vista Home Premium.
On the new machine i have attached the DNN database.mdf file to a machine instance of SQLExpress so I can administer the DNN database. I have created a DnnUser ( temporarily with sa rights ) that has access to the machine instance of SQL Express and the DNN database in SQLExpress. All looks well until i access the website. I am taken to the DNN web setup form.The first page indicates that it cannot find a valid Sql Server. On the Configure Database Connection page I have:
Selected SQL Server 2000/2005/2008 Database
Set the server to the Machine instance of SQLExpress
Set the database to the DNN Database
Not selected Integrated Security:
put in my user id: DNNUSer
Added the password
Selected Run as db Owner
Added an Object Qualifier:
But when I tested the connection I get:
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Login failed for user 'FEDWEB\DNNUser'.
The SQLExpress has been configured for SQL Server and Windows authentication
I have set the SQLExpress to use the DNNUser account in the Sql server Configuration Manager
My IIS connection string is:Server=FEDWEB\FEDWEBSQLEXPRESS;Database=DOTNETNUKE;User ID=DNNUser;Password=XXXXXXX
The Application Settings SiteSqlServer is: Server=FEDWEB\FEDWEBSQLEXPRESS;Database=DOTNETNUKE;User ID=DNNUser;Password=XXXXXXX
(passwords deleted)
Is my configuation workable. Any Ideas where I went Wrong?
Wayne