Beginning with SQL Server 2012, security privileges changed and you cannot use the LocalSystem account. Previously, you could use the LocalSystem account as the default for the sysadmin role, use authentication for SQL Server 2012 or later, use a domain account (including Administrator) that has the SQL Server sysadmin role or change the Log on as option for SQL Server Service to use a domain user that has the required privileges.
If the SQL Server is not part of a domain, you can use a local user that has the sysadmin role or change the Log on as option for SQL Server Service to use a local user that has the required privileges,
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center