[error] Cannot open user default database. Login failed.

• Jon80

  SSCrazy

  Points: 2598

  More actions

  March 11, 2009 at 5:45 am

  #384106

  On the same machine when running an ASP.NET application, I'm getting what seems to be a pretty much infamous error. As a matter of fact the first error was a command suggested for resolving this issue:

  Cannot open user default database. Login failed.

  Login failed for user 'ARMANI\ASPNET'

  Within SQL Management Studio, under Security > Logins > \ASP.NET, the default database is set to master. I've tried to change that to C:\Inetpub\wwwroot\TestWebSite\App_Data\ASPNETDB.MDF, which is the database file used by the application, to no avail.

  :w00t:

  Related links:

  http://www.codeproject.com/script/Forums/View.aspx?fid=1642&msg=2958694 - forum post

  http://forums.asp.net/t/939300.aspx - 2nd error

  http://www.sqlservercentral.com/Forums/Topic673100-1291-1.aspx?Update=1

• Doug S.

  SSCrazy

  Points: 2801

  More actions

  March 12, 2009 at 12:29 pm

  #958607

  The path is not the same as the name. Can you connect to the DB using SQL EM?

  If not you may need to do this via a system stored proc sp_Defaultdb or the ALTER LOGIN sql command.

  If possible I'd recommend moving the DB to a true SQL server instance where you can take advantage of the features in the DBMS (backups, restores, etc)

  Good luck

  ---

  Doug