Before you can add the database name to the MicrOpay Sign In screen, you need to know the SQL Server and Database Name. To find out this information:
For Desktop Customers:
Contact your IT team to obtain the SQL server and database names. Your local IT team will also be able to advise if you should select SQL or Windows authentication.
For instructions on entering a registration code, see Enter a Registration Code.
For information on SQL Server Permissions, see SQL Server permissions.
For Hosted Customers:
If you are unsure of the server and database names, raise a case online requesting the information. Include your client ID in the description.
To Locate the MicrOpay Database:
Once you have the SQL Server name and Database name, you can proceed with the steps below:
On the MicrOpay Sign In screen, click Find.
Enter the SQL Server Name and Payroll Database Name.
Select the authentication method. For hosted customers, this will be Use Windows NT authentication. If you choose SQL authentication, you will also need to enter the Login User and Password.
Click Next.
Untick Create a Common database on the same server.
Enter the SQL Server Name and Common Database Name.
Select the authentication method. For hosted customers, this will be Use Windows NT authentication. If you choose SQL authentication, you also need to enter the Login User and Password.
Click Finish.