Hi all,
This is a log shipping question. I have created a job to transfer the logins of a database to the secondary server (for role changes). Two of the steps in this job are Operating System Commands. In these steps, i have specified the username and password of the login used to transfer the logins.
Is there a way to get the password from SQL server itself or from a config file rather than typing it explicitely into the job steps. This would help in case i change the password. If i did, then i would have to change the password typed in the steps for each of the trasfer logins jobs i have created. it would be better to only have to change it in one place.
Thanks
This is a log shipping question. I have created a job to transfer the logins of a database to the secondary server (for role changes). Two of the steps in this job are Operating System Commands. In these steps, i have specified the username and password of the login used to transfer the logins.
Is there a way to get the password from SQL server itself or from a config file rather than typing it explicitely into the job steps. This would help in case i change the password. If i did, then i would have to change the password typed in the steps for each of the trasfer logins jobs i have created. it would be better to only have to change it in one place.
Thanks