Problem
In SQL Server 2012, you are configuring scheduled backup maintenance plans for your SharePoint 2013 farm databases. When you attempt to execute a maintenance plan, you experience the following error:
In SQL Server 2012, you are configuring scheduled backup maintenance plans for your SharePoint 2013 farm databases. When you attempt to execute a maintenance plan, you experience the following error:
Solution[date] [time],,Error,[298] SQLServer Error: 15404 <c/> Could not obtain information about Windows NT group/user [Account you are logged in as]<c/> error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
- Determine the domain account that you will use to login to SQL Server as (eg, spAdmin) to create the farm database maintenance plans.
- Launch Active Directory Users and Computers as administrator.
- Navigate to this account in the directory.
- Right-click this account and choose Properties.
- Select the Security tab.
- Click the Add button.
- Enter the SQL Server service domain account and click OK.
- On the Properties dialog, select this account in the Group or user names list.
- Ensure that Read is enabled and all its subpermissions (eg, Read account restrictions, Read general information, etc). Disabling and enabling Read automatically enables all the Read subpermissions.
- Click OK.
- SharePoint 2013: Service Account Configurations and Permissions
- Initial deployment administrative and service accounts in SharePoint 2013
- The error presented above appears in the SQL Server Error Logs: [ServerName] > Management > SQL Server Agent > Error Logs.
No comments:
Post a Comment