Hello all,
Just to document all that has been done to achieve the connection to the repository using Windows authentication:
1) DataMaker - This is an easy one. ODBC DSN driver has to be created using Windows Authentication. The procedure can be found currently in docops.
2) GT Subset - Copy SQLAUTH.dll 64 bit into Data Maker directory. The file can be found in C:\progfiles\gt\datamaker\sqlserver DLL's
3) TDodD Service - I understand this is slowly being replaced by the Portal, but CA ARD relies on that to use data painter. So, what needed to be done here is alter the connection string in the config TDoD config file to include "integrated security=true ;" userid and password must be removed as it is not required anymore. Check the connection is successful using the TDoD configuration tool. This in theory should be enough to start the service. But, if you click the "start service" button, the service will not start. Checking the TDoD logs, the userid logon string is not correct and the service won't start ( I have created a case with CA Support) . In order to fix that, a simple solution was to right click on the TDoD service on the "Windows Services" application. And provide the administrator user credentials manually. That will hopefully start the TDoD service successfully.
Thanks Manju, you provided great help .
Regards
Fabio Machado