Hello all!

I'm trying to install DNN 4.5.1 from install package.  I get the following error at the Database connection test.

----------------------------------------------------------
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 4064
Message: Cannot open user default database. Login failed.

Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Login failed for user 'ITNOTEBOOK\ASPNET'.

Index #: 2
Source: .Net SqlClient Data Provider
Class: 0
Number: 5111
Message: File activation failure. The physical file name

"C:\Inetpub\wwwroot\DNN\App_Data\Database_log.ldf" may be incorrect.
---------------------------------------------------------------------

I have Visual Studio 2005 installed and SQL Server Express was installed during that install, too.

I unzipped the files to C:\Inetpub\wwwroot\DNN\.  I set up the permissions for local ASPNET and file permissions test is successful.

The SQL Express log has the following entries about not being able to find a Database_log.ldf when the connection test is performed.  This log file is not in the install Zip and I'm not sure if it's created after first access to the database or at some other time.

Log
------------------------------------------------------------------------------------------------
2007-05-20 05:12:03.97 spid51      Starting up database

'C:\INETPUB\WWWROOT\DNN\APP_DATA\DATABASE.MDF'.
2007-05-20 05:12:04.22 spid51      Error: 17207, Severity: 16, State: 1.
2007-05-20 05:12:04.22 spid51      FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'C:\Inetpub\wwwroot\DNN\App_Data\Database_log.ldf'. Diagnose and correct the operating system error, and retry the operation.
2007-05-20 05:12:04.22 Logon       Error: 18456, Severity: 14, State: 16.
2007-05-20 05:12:04.22 Logon       Login failed for user 'ITNOTEBOOK\ASPNET'. [CLIENT: <named pipe>]
-----------------------------------------------------------------------------------------------

I tried to attach the Database.mdf to check it out in Managment Studio and I get a msg about not being able to attach the .mdf because it can't find "C:\DotNetNuke_Build\Website\App_Data\Database2.mdf" .  Don't know if this is a temporary folder for install purposes either.

Msg ------------------------------------------------------------------------------------------------
Attach database failed for Server 'ITNOTEBOOK\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

Directory lookup for the file "C:\DotNetNuke_Build\Website\App_Data\Database2.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)
------------------------------------------------------------------------------------------------

Any help is appreciated.

Thanks,
Ivan Torres

Sebastian,

Thanks for the quick reply and pointing me to the Blog.  I followed the instructions and was able to succesfully test the Database connection and complete the installation.

I had actually seen the article but at the time I wasn't quite aware of how it related to the problem I was having.  Reading it again and relating it to the error logs I'd seen made it more clear. 

I'm curious about the implications the running as User Instance and attaching to a particular .mdf as default vs. the way it's set up by this soution.  I'll look into that later.

Thanks again.
Ivan Torres