Hello All,

I have been asked to create a Windows service that will perform some tasks on multiple databases on multiple servers in multiple domains.

The question that I have at the moment is how to save the authentication information for each database. The databases are not in the same Windows domain and the domains are not trusted. Because of this I am not able to use a common OS account between all of the databases. The one option that I can come up with is to encrypt the login information somehow and then decrypt it when I need to make a connection.

Does anyone have a suggestion as to how I may be able to connect to these multiple databases?

Thanks Steve