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
>