It may not be the best way around, but in this situation I have set up a cmd backup script (fashioned after sqlfull.smp) that ran under SQLServerAgent, and set it to run under the same account that held sway over SQL Server. My errors ceased.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kamp, Bruce Sent: Wednesday, April 25, 2007 9:05 AM To: [email protected] Subject: [ADSM-L] TDP SQL Backups On some of my SQL servers rights have been taken away from the local system account to SQL. In the documentation I found that I can add the username & password to a user that has rights to backup SQL to the command file to run the backup. The problem with this is that it is in clear text so anyone who has rights to the server can see the username & password. Is there any other way to set this up? Thanks, --------------------------------------------------------------- Bruce Kamp Senior Server Analyst Memorial Healthcare System E-Mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Phone: (954) 276-4097 Fax: (954) 276-5381 --------------------------------------------------------------- ----------------------------------------- Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
