ADSM-L

Re: [ADSM-L] MSSQL 2012 SQL permissions

2016-06-14 23:56:24
Subject: Re: [ADSM-L] MSSQL 2012 SQL permissions
From: Stefan Folkerts <stefan.folkerts AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 15 Jun 2016 05:54:46 +0200
Thanks all!

On Tuesday, 14 June 2016, Del Hoobler <hoobler AT us.ibm DOT com> wrote:

> Also, keep in mind, the SYSADMIN role is a Microsoft requirement:
>
>         https://support.microsoft.com/en-us/kb/2926557
>
>
> Del
>
> ----------------------------------------------------
>
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU <javascript:;>> wrote 
> on
> 06/14/2016
> 12:47:50 PM:
>
> > From: Stefan Folkerts <stefan.folkerts AT GMAIL DOT COM <javascript:;>>
> > To: ADSM-L AT VM.MARIST DOT EDU <javascript:;>
> > Date: 06/14/2016 12:48 PM
> > Subject: Re: MSSQL 2012 SQL permissions
> > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU 
> > <javascript:;>>
> >
> > version 7.1.4 of de SQL TDP, legacy backups. The customer doesn't want
> the
> > MSSQL sysadmin role for backup purposes.
> >
> >
> > On Tue, Jun 14, 2016 at 2:12 PM, Rick Adamson
> <RickAdamson AT segrocers DOT com <javascript:;>>
> > wrote:
> >
> > > Stefan,
> > > Can you provide more information, like
> > >  -what version of SQLDP are you using
> > > -are you using the legacy data protection or Flash Copy Manager (FCM)
> > > -VSS or legacy backups
> > >
> > > On older versions I ran my scheduler with an administrator account and
> > > also had TSM admins added to sysadmin role in SQL in order to be able
> to
> > > troubleshoot backup issues as well as perform restores.
> > >
> > > On the releases the TSM admins still are added to the sysadmin role to
> > > provide support but I no longer install a scheduler service and use
> the
> > > scheduler internal to DP/FCM and don't use any elevated account.
> > >
> > >
> > > -Rick Adamson
> > >
> > >
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU
> <javascript:;>] On Behalf
> Of
> > > Stefan Folkerts
> > > Sent: Tuesday, June 14, 2016 5:33 AM
> > > To: ADSM-L AT VM.MARIST DOT EDU <javascript:;>
> > > Subject: [ADSM-L] MSSQL 2012 SQL permissions
> > >
> > > Hi all,
> > >
> > > Can somebody help me with the MSSQL 2012 SQL permissions that are
> needed
> > > for the scheduler user?
> > >
> > > I can find:
> > >
> > >
> > > https://urldefense.proofpoint.com/v2/url?
> >
>
> u=http-3A__www-2D01.ibm.com_support_docview.wss-3Fuid-3Dswg21368503&d=CwIBaQ&c=AzgFQeXLLKhxSQaoFCm29A&r=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw&m=UtpsaRjR1lo3cxWy8yN9atqFIsgPAifd7bsFQPM5HHc&s=7QYYsEEwqwIBQyXRYO8Ulr-65aYw-
> > NXOSOFPrINsjWs&e=
> > >
> > > But that's for 2005 and it doesn't list the MSSQL permissions.
> > >
> > > Regards,
> > >    Stefan
> > >
> >
>