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.
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