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