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://qa.sqlservercentral.com/Forums/Topic673100-1291-1.aspx?Update=1