SQL 2012 NT_Authority|System, sysadmin is not checked by default
Posted on 2014-04-02
I have an application from a 3rd party that requires a different setting on my SQL 2012. I'm not real familiar with MS SQL, but can follow instructions through the Microsoft SQL Server Management Studio and I have a couple of databases already setup and working. The vendor for the application is stating the following (see below), but I'm not real sure what needs to be done. Can someone give me the steps necessary to get this configured correctly?
Here is what they are telling me:
The service runs under the Local System (NT AUTHORITY\System) account. In SQL 2012 this Local System (NT AUTHORITY\SYSTEM) account is not automatically provisioned in the sysadmin fixed server role.