Skip to content
logo Knowledgebase

Error - Connection to server failed: X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server]MAX_PROVS: Error Locating masked/Instance Specified

Created on  | Last modified on 

Summary

Upon initial connection to an X3 Instance the following error may occur :- Either as a Sitemap Loading failed, or on access to a Classic function :- Error; Connection to server failed : X3 engine error : MicrosoftODBC Driver 17 for SQL Server MAX_PROVS: Error Locating >/Instance Specified xFFFFFFF.: ini_com:variable dimension:!(2)

Description

Cause

The X3 application server is unable to connect to the SQL Server database using an ODBC connection, possible configuration or access problem.

Resolution

Use the following to diagnose and confirm connection :-

Use the ODBC Data Source Administrator app: type ODBC at your Windows icon to start

This will enable you to replicate the connection that X3 is using to connect to SQL Server and test its validity.

Enter the 'System DSN' tab

Select the data source and 'Configure'

Confirm the datasource name and server are set

Confirm the authentication method and enter any required login/password

Confirm further SQL Server settings and Finish

Enter 'Test Data Source'

This will execute connectivity tests and advise if tests were successful or failed.

If an error is returned: 'Server is not found or inaccessible'

Check your ports and firewall access to the SQL Server :

The standard ports are 1433 TCP and 1434 UDP

Modify if required and re-perform the ODBC connectivity test.