MOSS Form Authentication -- EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'

When enabled form authentication in my MOSS 2007 i'm getting "EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'"

Later exploring the problem and found the solution. By executing the following SQL commands will solve the problem.

USE aspnetdb
GO
sp_addrolemember 'aspnet_Membership_FullAccess', 'Network Service'


“Network Service” is your user name.

Comments

Popular posts from this blog

ASP.NET website "Cannot read configuration file due to insufficient permissions" in IIS 7 and Windows Server 2008

Error occurred in deployment step 'Install app for SharePoint': The System Account cannot perform this action.

None of the selected features can be installed or upgraded. Setup cannot proceed since no