I am having some moderate to severe issues with accessing my portal locally. I have not deployed it to the web server yet, but have not had any issues accessing the portal to work on it. It is configured with SQL Express 2005 and my DNN version is 4.7. I am now getting a message when I run the web app from Visual Studio 2005 that states the following:

This site is currently Unavailable

Please check back later

I close the application and try to re-run it and get the following:

System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'computerName\ASPNET'.

If I do an IIS reset I get the first message again.

I have added the computerName\ASPNET in the server security settings/logins on SQLExpress and added the user with dbo rights. I am still getting the above error. I know this is probably something simple ... but I'm out of ideas. Any suggestions would be greatly appreciated.

Ian,

Thanks for the quick response. The user has dbo.owner privileges. I located the culprit about 30 minutes ago, although I don't know why the setting changed. The App_Data directory on the web server was set to read-only and the child files did not have permissions to access the database. I reset these to full permission and everything works again. Do you have any idea how these permissions may have gotten changed?  The only thing I did was to open the database in Management Studio and add  a table and a stored proc to handle a contacts module I was writing.

Thanks again,

Rob