Thanks all! On Tuesday, 14 June 2016, Del Hoobler <[email protected]> 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" <[email protected] <javascript:;>> wrote on > 06/14/2016 > 12:47:50 PM: > > > From: Stefan Folkerts <[email protected] <javascript:;>> > > To: [email protected] <javascript:;> > > Date: 06/14/2016 12:48 PM > > Subject: Re: MSSQL 2012 SQL permissions > > Sent by: "ADSM: Dist Stor Manager" <[email protected] <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 > <[email protected] <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:[email protected] > <javascript:;>] On Behalf > Of > > > Stefan Folkerts > > > Sent: Tuesday, June 14, 2016 5:33 AM > > > To: [email protected] <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 > > > > > >
