Hi, I have recently downloaded an old website that I created for one of my customers. It uses SQL server 2008 as a database and I have "restored" the conection to my local Sql server. I can connect to the database and work with its contents from the Server
Explorer in VS2008. The problem is that I can't connect to it using the AST.NET configuration tool for Membership handling. When I try I get the following message:
Cannot open database "XXXXX" requested by the login. The login failed. Login failed for user 'Otto-PC\Otto'.
I have now been struggeling with this for more than a week with no result and wloud very much appreciate any solutions that might solve the problem.
but sorry if I seem stupid, where and how do I do that. I can't find that user anywhere. Or should I ask, who is the Application Pool User? Do I give the permission in SQL Server or in IIS?
sveasen
Member
2 Points
2 Posts
ASP.NET Configuration pemissions in SQL Server 2008
Feb 19, 2012 06:02 AM|LINK
Hi, I have recently downloaded an old website that I created for one of my customers. It uses SQL server 2008 as a database and I have "restored" the conection to my local Sql server. I can connect to the database and work with its contents from the Server Explorer in VS2008. The problem is that I can't connect to it using the AST.NET configuration tool for Membership handling. When I try I get the following message: Cannot open database "XXXXX" requested by the login. The login failed. Login failed for user 'Otto-PC\Otto'. I have now been struggeling with this for more than a week with no result and wloud very much appreciate any solutions that might solve the problem.
Otto
HostingASPNe...
All-Star
15882 Points
2977 Posts
Re: ASP.NET Configuration pemissions in SQL Server 2008
Feb 19, 2012 07:55 AM|LINK
Hello,
You should give security permissions to the application pool user.
Regards
Free ASP.NET Examples and source code.
sveasen
Member
2 Points
2 Posts
Re: ASP.NET Configuration pemissions in SQL Server 2008
Feb 20, 2012 09:38 PM|LINK
OK thanks,
but sorry if I seem stupid, where and how do I do that. I can't find that user anywhere. Or should I ask, who is the Application Pool User? Do I give the permission in SQL Server or in IIS?
O
Chen Yu - MS...
All-Star
21584 Points
2493 Posts
Microsoft
Re: ASP.NET Configuration pemissions in SQL Server 2008
Feb 24, 2012 05:19 AM|LINK
Hi Otto,
From your error message, I found these thread which is similar to your issues. It may help you.
Please see: http://stackoverflow.com/questions/2575907/cannot-open-database-test-requested-by-the-login-the-login-failed-login-fail
http://blog.sqlauthority.com/2009/08/20/sql-server-fix-error-cannot-open-database-requested-by-the-login-the-login-failed-login-failed-for-user-nt-authoritynetwork-service/
Thanks.
Feedback to us
Develop and promote your apps in Windows Store
ryanbesko
Contributor
3561 Points
619 Posts
Re: ASP.NET Configuration pemissions in SQL Server 2008
Feb 24, 2012 04:16 PM|LINK
Please see my answer in this thread:
http://forums.asp.net/t/1769531.aspx/1?help+with+connection+string+for+newly+created+database+in+SQLExpress