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

PROBLEM

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. 



SYMPTOMS

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



RESOLUTION

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.



APPLIES TO

CCM All versions 

Keywords: sql permissions requirements SQL 2012 2014



Rate this Article:
     

Add Your Comments


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

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