Connecting to SQL Server I currently have set the Server Role sysadmin on the account accessing SQL Server where I'm about to host Sitecore databases. My guess is that it's way to much privileges for the account, and really wonder if dbcreator would be the correct Server Role for the SQL Server account?

enter image description here

1 Answer 1


You are right, you granted to much privileges. You don't have to assign any server roles, but you should should assign db_datawriter, dbreader and public role memberships for your user to the web and master databases. You should also assing execute permissions on all the stored procedures for your db user.

for the core database, assign the following role memberships:

  • db_datareader
  • db_datawriter
  • public
  • aspnet_Membership_BasicAccess
  • aspnet_Membership_FullAccess
  • aspnet_Membership_ReportingAccess
  • aspnet_Profile_BasicAccess
  • aspnet_Profile_FullAccess
  • aspnet_Profile_ReportingAccess
  • aspnet_Roles_BasicAccess
  • aspnet_Roles_FullAccess
  • aspnet_Roles_ReportingAccess

edit: most recent public installation guide that I found: https://dev.sitecore.net/~/media/Downloads/Sitecore_Experience_Platform/8_0/Sitecore_Experience_Platform_8_0/Non-secure/Installation-Guide-SC80-A4.ashx

The best advice is to follow the installation guide for your version, download it on https://dev.sitecore.net

  • 2
    I agree with this except for the dbcreator role. This shouldn't be assigned. Oct 11, 2016 at 6:19
  • 2
    You are so right, that was a big mistake by me. Good thing you mentioned it!
    – Bas Lijten
    Oct 11, 2016 at 7:09
  • dbcreator would be required initially for installation though - right?
    – Chris Berg
    Oct 12, 2016 at 13:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.