Gautam Buddha Temple Varanasi,Varanasi - Buddhist Pilgrimage

Sunday, August 11, 2013

EXECUTE permission denied on object 'usp_login', database 'Database', schema 'dbo'

Please check your database user roles. It's necessary the database user to be owner. What you should instead do, is grant the user the following Roles: - aspnet_Membership_FullAccess - aspnet_Roles_FullAccess - etc. depending on what features you have enabled/installed into this database Do this by using Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express 1. Connect to the database you are working with 2. Open Databases 3. Open the database you are working with 4. Open Security 5. Open Users 6. Double-click the user who is accessing the database 7. In the list of Owned Schemas, check off the roles indicated above

1 comment:

  1. This is an amazing blog,it gives very helpful messages to us.Besides that Wisen has established as Best Dot Net Training in Chennai. or learn thru ASP.NET Online Training . Nowadays Dot Net has tons of job opportunities on various vertical industry.