Error message appears on using a machine data source: "There was a problem opening the synchronization data source".

SYMPTOMS

Error message on selecting a machine data source: When creating an ODBC Data source the Database (Oracle / SQL) is installed on a remote server the following error appears: "There was a problem opening the synchronization data source".

CAUSE

Incorrect authentication method used

RESOLUTION

The logged on user requires sufficient permissions to access to the database .

• From the Administrative tools select: ODBC Data Sources (32-bit)
• In the ODBC window select: System DSN select: ADD button
• In Create New Data Source select:Sql server
• In ODBC Microsoft Access Setup, press enter
• Specify the Datasource Name: xxxxxx
• Select the applicable Servername
• SQL server should verify the authentication using the network login ID.
• Use Windows NT authentication with the correct network login ID

'There was a problem opening the synchronization data source.' message will no longer appear.

APPLIES TO

6.1