I have a situation that has left me really scratching my head. This is a SQL Server 2008r2 instance, used as the database server for a substantial corporate SharePoint service. As my company is ...
Which user does Windows Authentication of a maintenance plan authenticate? before whom, why and for what?
I am having a maintenance plan configured with Windows Authentication being run by an SQL Server Agent job with owner sa Whom does Windows Authentication of a maintenance plan authenticate, ...
How to give the least permissions for CRUD-managing and running SQLServerAgent jobs as well as Maintenance Plans?
Follow up to my question "What's the owner of SqlServerAgent job for?" Basically, I am trying to understand how to create a user-login with least privileges for CRUD-maintaining SQLServerAgent jobs ...
What is the possible use of owner of an SQL Server Agent job, I wonder? Removed, and left it blank and the job still succeeds
I have a weekly and nightly SQL Server Agent jobs executing a weekly and nightly maintenance plans, resp. These weekly (on Sunday) and nightly (on other 6 nights of the week) maintenance plans ...