March 11, 2009 at 5:45 am
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
March 12, 2009 at 12:29 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply