DI commissioning

• commissioning of the exchange data interface is done in the EC configuration - Main tab at the top (Vault Explorer menu - Tools / CS ErpCnn 2G / Configuration...)

• verify that the TCP/IP protocol is enabled on the SQL Server, or find out the port number (SQL Server configuration manager)

• set Connection string in ec cfg - one of the patterns can be used:

• • integrated security pattern (domain security)

  • user/password pattern

• Check DI availability with the Test button

• if you can't connect:

  • for a named SQL server instance, the server name must include the instance name: e.g. dbsrv\autodeskvault

  • verify the availability of the target SQL server using ping

  • try replacing the SQL server name with its IP address

  • add to the connection string the port number on which SQL is running: e.g. dbsrv\autodeskvault,1433

  • verify that the firewall is not blocking communication on the port

  • connectivity to the SQL server can be independently verified e.g. by:

    • Excel (Data / From other sources / From SQL server) or "New data source"

    • Control Panel - 'Data Source Manager'

  • if the Test passes, confirm the creation of DI

  • save configuration (Save)

  • DI is up and running