The error message can indicate one of the following;
The database server name entered does not match a SQL instance.
The database server name entered does not have SelectPay installed.
The username entered does not have sufficient SQL permissions.
Incorrect database server name
The database server name field should be the SQL server instance. If you are self hosted, check with your local IT team to ensure the name is correct and that the database AA_USER_MANAGEMENT exists.
If you are hosted and have access to the SelectPay Administrator, raise a case with the support team.
SQL permissions
🤓Tip: The username and password for the SelectPay Administrator is a SQL account and is different to your SelectPay client account.
The roles that needs to be assigned to your SQL user account are below. To do this, follow the steps below.
AA_ADMINISTRATOR_R on AA_USER_MANAGEMENT.
AA_PAYROLL_R on each SelectPay database.
Using an administrator account, login to your SQL server.
Press the Windows key, and search for 'SSMS'
Click SQL Server Management Studio.
Login using an SA account or equivalent.
Click the + to expand Security, and then Logins.
Right-click the user name that can't login.
Click Properties, and then click User Mapping.
For the AA_USER_MANAGEMENT select the Map checkbox.
Select the AA_ADMINISTRATOR_R checkbox.
Select the required database from the list.
Click the AA_PAYROLL_R checkbox.
Repeat steps 10 and 11 for each database required.
Click Ok.