Highlighted
Micro Focus Expert
Micro Focus Expert
187 views

(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>'

(UserId='<username>')

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       

 

Response:

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.

Reference: https://softwaresupport.hpe.com/km/KM02788304

MICRO FOCUS Software Support
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.
Labels (1)
Tags (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.