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: bkamp AT mhs DOT net
Phone: (954) 276-4097
Fax: (954) 276-5381
---------------------------------------------------------------

-----Original Message-----
From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
Sent: Wednesday, April 25, 2007 12:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
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" <ADSM-L AT VM.MARIST DOT EDU> 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?