What I was trying to use was a windows AD account. I wanted to use this because this going to become a standard in my organization.
Thanks, --------------------------------------------------------------- Bruce Kamp Senior Server Analyst Memorial Healthcare System E-Mail: [EMAIL PROTECTED] Phone: (954) 276-4097 Fax: (954) 276-5381 --------------------------------------------------------------- -----Original Message----- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 12:37 PM To: [email protected] Subject: Re: [ADSM-L] TDP SQL Backups Bruce, If you want to use SQL Server authentication. i.e. /SQLAUTHentication=SQLuserid Did you try to use the GUI---> Utilities ---> SQL Server Login Settings to set your SQL Server login id and password? Then, stop the DP/SQL GUI... and try this command: TDPSQLC QUERY SQL /SQLAUTHentication=SQLuserid /sqluser=user and then TDPSQLC BACKUP dbname FULL /SQLAUTHentication=SQLuserid /sqluser=user Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 04/25/2007 10:04:48 AM: > 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?
