(UCMDB) Support Tip Asset Manager push adapter, SQL server with a name instance
Starting the AssetManager generic push adapter, using SQL server, return the following error message, when trying to connect to a named instance :
Caused by: Error (12,001): ODBC: Unable to connect to database '<dbname>-<unique connection id>'
Unable to connect to this database engine.
The user name, database name, and ip of the SQL server connection are correct
The error message could also be: can't connect, database does not exist, or access denied
SQL server, is able to use named instances.
For example, you can get one default instance on one machine, and 2 named instances, called : instance1 and instance2.
Whenever you want to connect to a default instance, you can as hostname use the DNS name of the default instance machine.
But, if you want to connect to a named instance, the hostname syntax has to be:
For example :
named instance SQL1 on machine mysqlserver.com
hostname must be : mysqlserver.com\SQL1
default instance on machine mysqlserver.com :
hostname must be : mysqlserver.com
Then, sql server will allow the connection to the named instance.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Please hit the Kudo botton, if you find this post useful.