Re: [ADSM-L] MSSQL 2012 SQL permissions
2016-06-14 13:54:04
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> wrote on 06/14/2016
12:47:50 PM:
> From: Stefan Folkerts <stefan.folkerts AT GMAIL DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> 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>
>
> 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>
> 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] On
> > Behalf
Of
> > Stefan Folkerts
> > Sent: Tuesday, June 14, 2016 5:33 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > 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
> >
>
|
|
|