Tip #105: Can I remove SQL SysAdmin and Local Administrator permissions

A question that is frequently raised in large enterprise deployments of Microsoft Dynamics CRM is can the local administrator and SQL SysAdmin permissions be removed from the installing user after the installation. The answer is “yes, but…”

Yes, you may remove these permissions after the installation is complete. The user who performed the installation will be able to log into CRM without having these permissions.

But…keep in mind that when it comes time to install an update rollup, to perform the database update, the user installing the update will need to have SysAdmin privileges in SQL Server.

Tweet about this on TwitterShare on Facebook0Share on Google+0

One thought on “Tip #105: Can I remove SQL SysAdmin and Local Administrator permissions

  1. RobN says:

    It would be nice if Microsoft stated this in their documentation so revoking this permission would actually be supported. Better yet, if they defined a set of granular permissions so sysadmin wouldn’t need to be granted in the first place.

Leave a Reply

Your email address will not be published. Required fields are marked *