Hello & thank you in advance:

I am trying to install a new iteration of DNN on my localhost.  The other installs work perfectly.  I am getting this message when I test the database connection:

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 'XP\ASPNET'.

Index #: 2
Source: .Net SqlClient Data Provider
Class: 0
Number: 5111
Message: File activation failure. The physical file name "C:\DotNetNuke Sites\wdf\App_Data\Database_log.ldf" may be incorrect.

Any help would be greatly appreciated...

I think that "login failed" is the key issue. The "user" that you specified seems to be XP/ASPNET.

Can you provide more details of how you specified the login connection? That information is on the Wizard screen. Also, since you have entered and tested the connection, I think that the connection string created by the Wizard is now in your web.config file. What is it?

And, can you connect to the database using SQL Server Management Studio Express or other tools? If so, what username/password to you use to do that?

Thank you for your quick response!

I didnt specify the login information, it jujst came up that way.  
Server: .\SQLExpress
Filename: Database.mdf
Integrated Security is checked
Run as db Owner is checked

Object Qualifier is empty

I am able to connect using Studio Express with Windows Authentication XP\XP-User (no PW).   but once i am in to Studio Express, I dont see the databases that I have set up previously for a test install and a skinning install of dnn--then again, I am not sure where to look...

 <!-- Connection String for SQL Server 2005 Express --> 


If there is more information I can provide, please let me know...

dp

Just to make sure, are you installing this to a completely new DNN folder as a new installation?

The DNN databases for SQL Express are not automatically attached into SQL Express, they are placed in the app_data folder of your DNN installation files and the connection string in the web.config by default is setup to connect to the database in the app_data folder.

I would suggest you start the installation again by deleting your new installation folder, creating a new one and copying some fresh DNN installation files in there. Make sure you setup the persmissions on the new DNN files and folders.

Lee:

Thank you! I am SURE that is it. I haven't tried as I am a bit swamped with some other deadlines. I will play in a bit and post my results....

I checked and re-checked the permissions, but then I deleted the directory and created a new one, reset the permissions and reset the virtual directory and all is well. AGAIN thank you for all the help!

Great! Glad you got it working

Lee,

What application(s) do you use to create your tutorials?

dp

camtasia, previously it was captivate - but there are also other processes involved to get the edit to the high standard

I can only imagine how many hours it takes you to create the tutorials (which, by the way are fantastic).

yes a lot a lot a lot of hours! - Glad you like the vids, thanks,

I rarely pay for subscriptions to sites, but dnnCreative.com is worth many time the cost of admission (even in $US). I spent close to $300 on dnn books that I havent opened since I subscribed to dnnCreative!

Your hours of work are very much appreciated!

Best,

dp