Search this insane blog:

Sunday, June 15, 2008

Membership database permissions.

sp_help 'aspnet_CheckSchemaVersion'
-- if the website has an error lke
-- EXECUTE permission denied on object 'aspnet_CheckSchemaVersion'...
-- look inside your database to decide who gets permissions.

sp_addrolemember 'aspnet_Membership_FullAccess', 'username'


note: if you don't know anything about asp.net memberships and have the SQL server management studio, search for the application on your computer called aspnet_regsql.exe.

That will pop up a wizard and will install the membership database you will neeed for membership on your asp.net website.

background: I stumbled upon this when I installed asp.net's default personal webpage template.

No comments:

Post a Comment