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?
