Sitecore Azure and Database Permissions
I recently setup a Sitecore Azure 7.5 environment and deployment. However I came across one aspect of my deployment I found odd…..
In this architecture, the client decided that to host the content management environment with an external provider and utilize Azure as content delivery environments.
So I applied the aspects of the hardening guide to the content management environment. When it came time to setup the Azure instance, I received an error regarding that the permission was denied to the database during deployment.
In following section 4.4 of the Sitecore installation guide for Sitecore version 7.5, I did the following:
8. In the Database role membership for field, select the following check boxes:
For the Master and the Web databases:
The Core database had the same roles plus other aspnet_* roles.
Well providing db_owner rights seemed to get me through the initial setup process with no issues. I reverted the changes now that the environment was setup and am not having any other issues.
I haven’t been able to figure out if this was some weird occurrence or a consistent bug. Curious to see if anyone else has come across the same annoying little issue.