Cannot Access the SQL Server Client Engine or SQL Server
- Check ODBC Data Source definitions using ODBC Administrator, ensuring that the server name is correct.
- Check selected protocol by running SQL Client Configuration Utility (SQL Server Tools group).
- Test your ability to communicate with the server by using ISQL/w.
- Start ISQL/w.
- Select the database from the drop-down list in the dialog box.
- Enter the following SQL statement, and execute.
select TABLENAME from DATADICT
- Check the Sage 300 database profile by running the Sage 300 Database Setup utility. Make sure the correct information is specified for the databases.