The issue is caused by the Windows account assigned to the SelectPay service does not have the required SQL permissions to the user management database. The two solutions are, change the service user or grant the user SQL permissions. To do this, follow the relevant steps below.
Service user
Log in to your server that hosts the SelectPay service.
Click the Windows icon and search for 'services'.
Click Services, and right-click the current SelectPay service.
🤓Tip: The SelectPay service contains its release year in the title; if you have multiple, select the current tax year.
Click Properties, and then click the Log On tab.
Update the credentials for the listed account.
Click Apply, and then click Ok.
SQL permissions
Log in to your SQL server.
Click the Windows icon and search for 'SQL Server Management Studio'.
Click SQL Server Management Studio.
Enter the required credentials, and then click Connect.
Click the + icon to expand databases.
Click the + icon to expand AA_ACCESS_USER_MANAGEMENT.
Click the + icon to expand Security.
Click the + icon to expand Users.
Right-click Users, and then click New User.
Click the user type drop-down, and click Windows user.
Enter the Windows user that is assigned to the service.
Enter the default schema as '[dbo]'
Click Membership, and then select the AA_SERVICE_USER_R checkbox.
Click Ok.
Restart the SelectPay service.