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 <rickadam...@segrocers.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@VM.MARIST.EDU] On Behalf Of > Stefan Folkerts > Sent: Tuesday, June 14, 2016 5:33 AM > To: ADSM-L@VM.MARIST.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 >