Something missing from this is permissions. Grant EXECUTE and also double-click on the user in SSMS to add database role memberships. Good memberships to hold are:
- db_accessadmin
- db_backupoperator
- db_datareader
- db_datawriter
- db_ddladmin
- db_owner
- db_securityadmin
No comments:
Post a Comment