9

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

7

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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