Unable to connect to target database: Call to SQLError Failed

From support-works
Revision as of 12:56, 26 January 2018 by Pamelal (talk | contribs)
Jump to navigation Jump to search

Status: Published
Version: 1.0
Authors: HTL QA
Applies to: Core Services Version 3.1.x

Supportworks is able to work with Mysql and MSSQL. Normally for database connections, the default username is root and there is no password but should customers set up MSSQL, there would be a need to set a username and password for their database connection. When using the Database Schema Editor without specifying the DSN connection details you might get the following error:

In order to rectify this errors, follow these instructions:

From the Database menu in the Schema Editor choose the first option to Manage Entities. This will list the connector to your database and you can set the correct username/password from here. Out of the box this is set to root with no password. If this has been changed, you will then need to put the updated credentials in here.