https://community.netapp.com/t5/Data-Protection/smsql-sql-agent-backup/m-p/98878#M4780 <P>I created SMSQL scheduled backup job throught the SQL Agent.&nbsp;The snapdrive service account was used for the SQL Agent backup job and&nbsp;the default schema for that account on SQL is dbo. IA (information assurance)&nbsp;folks did not like the dbo beacuse it has too much priviledge. Can a lower priviledged schema be applied and still allow the scheduled Agent backup to work?</P> Thu, 05 Jun 2025 05:20:27 GMT _NETAPPUSER 2025-06-05T05:20:27Z https://community.netapp.com/t5/Data-Protection/smsql-sql-agent-backup/m-p/98878#M4780 <P>I created SMSQL scheduled backup job throught the SQL Agent.&nbsp;The snapdrive service account was used for the SQL Agent backup job and&nbsp;the default schema for that account on SQL is dbo. IA (information assurance)&nbsp;folks did not like the dbo beacuse it has too much priviledge. Can a lower priviledged schema be applied and still allow the scheduled Agent backup to work?</P> Thu, 05 Jun 2025 05:20:27 GMT https://community.netapp.com/t5/Data-Protection/smsql-sql-agent-backup/m-p/98878#M4780 _NETAPPUSER 2025-06-05T05:20:27Z https://community.netapp.com/t5/Data-Protection/smsql-sql-agent-backup/m-p/98895#M4781 <P>Hello,</P><P>SMSQL requires to run with a user which is sysadminon each managed SQL instance and it requires that user to be a local admin.</P><P>hope that clarifies it.</P><P>Domenico.</P> Tue, 06 Jan 2015 07:40:56 GMT https://community.netapp.com/t5/Data-Protection/smsql-sql-agent-backup/m-p/98895#M4781 dmauro 2015-01-06T07:40:56Z