CA Client Automation

Currently, I'm trying to integrate CA SDM 17 with CA ITCA 14, but when I install CA ITCM, the following error appears.

Currently, in my environment is already installed and in operation "CA SDM with the mdb"

Note: my environment is installed in a distributed way, that is:

Server 1: mdb
Server 2: SDM

and at the moment, I'm trying to install ITCM on server 3.
but when I register the parameters of the server of the mdb "database" it shows me the following error

---------------------------------

06/12/18 17:57:21.0959|3444:| <   Description   : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.    Source        : Microsoft SQL Server Native Client 11.0    Error Message : Unspecified error >

---------------------------------

Notes:
**already check the host files, and the three servers have communication
**No Firewall
**on the database server, create the Operative System and Database users

but the error persists

Server ITCA

**it is necessary change the port ?

Server MDB:

Any idea of what is still to be done? and how to solve it?

Attachment log

Regards,
Marco Velazquez.

Is the hostname of the mssql server really MDB with an instance name of SDMDaySet?

If so try this from a command prompt on the Client Automation  application server

sqlcmd -S MDB\SDMDaySet -Q "set nocount on; select mdbmajorversion,mdbminorversion,buildnumber FROM mdb.dbo.mdb" -h -1”

You should get back (1    5             1).  Else look at the log file that is listed in your screen shot for hints.

Also the user doing the install must be an admin on the Client Auto application server and SA rights to the database.

Richard Lechner

Principal Engineering Services Architect

CA Technologies

Mobile: +1 703 655 7161 | Richard.Lechner@ca.com

<mailto:Richard.Lechner@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>

Hello Richard,

I comment you, that the problem originated because the ITCM14 "Administrator" user of the ITCM operating system, did not exist in the database server "mdb"

and it is resolved by creating the user directly in the SQL server

thanks for your help.

Regards,
Marco V