You are trying to access your ASP.NET page and getting this message:
Cannot open database “YourDB” requested by the login. The login failed.
Login failed for user ‘YourPC\ASPNET’.
Use SQL Manager, navigate to Security ==> Logins.
Double click on ASPNET user and go to User Mapping.
Select YourDB and make sure ASPNET marked as both db_owner and public.
Be the first to comment