Cannot Access the Database Software
If you are using Microsoft SQL Server:
- Check ODBC Data Source definitions using ODBC Administrator. Ensure that the server name is correct.
- Check selected protocol by running SQL Client Configuration Utility (SQL Server Tools folder).
- Test your ability to communicate with the server by using ISQL/w.
- Start ISQL/w.
- Select database from drop-down list at top of dialog box.
- Enter the following SQL statement:
select TABLENAME from DATADICT and execute
- Check the Sage HRMS Payroll database profile by running the Sage HRMS Payroll Database Setup utility. Make sure the correct information is specified for the databases.