Sunday, February 19, 2012

aspnet account and sql server 2005

can anyone give me step by step instructions as to how I would go about correctly granting the aspnet account access to my sql server 2005 database ??

As far as I can see Ive set it up, but im getting execute permissions errors on stored procedures even though Ive gone into properties and permissions and added the aspnet account with execute permissions.

There are no properties involved in granting Asp.net permissions in your database, you create the server permissions in the security section under management in Management Studio and you create the database permissions in the new security section in the database section of Management Studio. Hope this helps.

No comments:

Post a Comment