SQL Security requirements with SQL 2012 and 2014

Expand / Collapse

SQL Security requirements with SQL 2012 and 2014

Article ID: 52210 - Last Review: October 3, 2014


In order to properly create and configure databases, the user we install with needs to have both sysadmin and dbcreator permissions in SQL. 

In SQL 2012 and 2014, these are no longer applied by default to the Local System account, and as such you may need to launch SQL Management Studio and add these permissions if they are missing. 


Without these permissions you may encounter SQL errors during upgrades, or Local System databases won't be able to be created. 


1. Open SQL Management Studio
2. Go to Security > Logins
3. Ensure that under Properties > Server Roles, your NT AUTHORITY\SYSTEM and the Windows account you use for upgrades are both allowed dbcreator and sysadmin.


CCM All versions 

Keywords: sql permissions requirements SQL 2012 2014

Rate this Article:

Add Your Comments

Name: *
Email Address:
Web Address:
Verification Code:

Last Modified:Friday, October 03, 2014
Last Modified By: AndrewM
Type: FIX
Article not rated yet.
Article has been viewed 10,933 times.