-
Title
Setting up SQL Server® Authentication for SQL Server 2012 or later -
Description
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,
-
Cause
To use SQL Server Authentication with SQL Server 2012 or later to configure the plug-in:1 Ensure that the selected domain or local user account has the sysadmin role assigned to it.
2 Complete one of the following:• In Windows Control Panel > Administrative > Services, locate and select NetVault Process Manager, and click Stop. Right-click NetVault Process Manager, and select Properties. On the Log On tab, ensure that NetVault Backup runs using the account that has the SQL Server sysadmin role. Start the NetVault Process Manager.
• In the SQL Server Configuration Manager, click SQL Server Services. In the details pane, right-click the name of the applicable SQL Server instance, and click Properties. In the SQL Server Properties dialog box, click the Log On tab. For Log on as, select the account that has the SQL Server sysadmin role. In Windows Control Panel > Administrative > Services, stop and start the SQL Server Service.
• Use SQL Server Management Studio, to add the domain or local user account that has the sysadmin privileges to the SQL Server. You can use SQL Server Management Studio to add this account, or enter the following in a command prompt:
-
Resolution
CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;GOFor more information, see https://technet.microsoft.com/en-us/library/ms189751%28v=sql.110%29.aspx.
SP_ADDSRVROLEMEMBER '<domainName>\<loginName>', 'sysadmin'
GOFor more information, see https://technet.microsoft.com/en-us/library/ms186320(v=sql.110).aspx.
-
Additional Information
For further information, please see the NetVault Backup: Plugin for SQL Server User's Guide, located here: https://support.quest.com/technical-documents/netvault-backup-plug-in-for-sql-server/10.0.6/user-guide#TOPIC-341974