UCMDB and UD Practitioners Forum (Previously CMS)
cancel

SQL Discovery fails with NT Authentication

Highlighted
Atul72
Honored Contributor.

SQL Discovery fails with NT Authentication

Hi,

We are trying to discover SQL Servers, and using HP UCMDB 8.02.

While defining the credentials for Discovery ,we tried to pass the SQL Server credentials and got success.

But while Passing NT Credentials, we are getting error?

Please let me know whether UCMDB SQL Discovery ssupports NT Credentials?

 

P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. -HP Forum Moderator

3 REPLIES
Dmitry Shevchenko
Acclaimed Contributor.

Re: SQL Discovery fails with NT Authentication

Yes, Windows credentials are supported for SQL Server discovery. While adding an entry for SQL Protocol you have to select "MicrosoftSQLServerNTLM" as the database type and provide desired windows account credentials - domain\username and password.
Alexander Arkhi
Acclaimed Contributor.

Re: SQL Discovery fails with NT Authentication

What kind of error are you getting?
Please let us know as much information as possible in order to get a proper assistance.
Atul72
Honored Contributor.

Re: SQL Discovery fails with NT Authentication

Attached is the solution