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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy