ADSM-L

Re: [ADSM-L] TDP SQL Backups

2007-04-27 15:32:23
Subject: Re: [ADSM-L] TDP SQL Backups
From: "Kamp, Bruce" <bkamp AT MHS DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 27 Apr 2007 15:31:30 -0400
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: 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 1:23 PM
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT 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 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?

<Prev in Thread] Current Thread [Next in Thread>