AnsweredAssumed Answered

How to use alternative login in CONN object?

Question asked by LeonardOlteanu on Mar 15, 2018
Latest reply on Mar 19, 2018 by Wolfgang_Brueckler_1288
We have a couple of CONN objects we use to connect to SQL Server databases. The DB login credentials are saved in the CONN object, but we would like to centralize all DB credentials in a LOGIN object, and then reference that LOGIN object in the "Alternative Login" field in the CONN object.
The problem is that I could not find any information on how to store DB credentials in the LOGIN object. The login type SQL seems to work only with agent names, not with DB server names. How would an entry in the LOGIN object look like in this case? Is this even possible?

Outcomes