I recently accessed my DOCX 5 database from the SQL management console. After that I get the following message:
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
I tried detaching from the database and still get the same error. I've also restarted the web site by touching the web.config file. When re-attach to the SQL database the data seems fine. After some research I've found the following link that may apply:
http://msdn.microsoft.com...ibrary/ms229862.aspx
However the wizard explains that removing information about ASP.NET membership, profiles, role management, perosnalization and SQL Web even provider from the database. Note: This process cannot be undone.
At this point I am looking to know if I'm headed in the right direction or if I have other options. We have a fair amount of information in the database so I'm hoping to save what we have. Any help would be appreciated. Thank you.