ADSM-L

Re: [ADSM-L] TDP SQL Backups

2007-04-25 13:35:50
Subject: Re: [ADSM-L] TDP SQL Backups
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 25 Apr 2007 13:23:07 -0400
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>