I finally got this working! Thanks for the help. I found out why it wasn't working the user wasn't given sysadmin rights to SQL.
My DBA's would like to know why the user can't only be in the backup operator role. 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 1:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP SQL Backups Bruce, In that case... you simply need to set the "Log On As" account for the scheduler service to the Windows userid that has been given permission on the SQL Server. Userid and password on the command-line are only meaningful for /SQLAUTHentication=SQLuserid. Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 04/25/2007 01:09:01 PM: > 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. > >========================================================================= > > Sent: Wednesday, April 25, 2007 12:37 PM > To: ADSM-L@VM.MARIST.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@VM.MARIST.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?
