|
Author:
Author Bio:
Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...
|
|
|
Security for SQL Agent Job Execution
In this video Brian explains what security options are available when executing job from within the SQL Server Agent in SQL Server 2005 / 2008
|
Video Information
|
Publish Date:
|
December 15, 2008
|
Length:
|
5:1
|
Skill Level:
|
100
|
Rating:
|
4.42 out of 5
|
|
|
|
|
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
good
|
|
|
Too fast for us newbies! Please make it slower next time. We do not mind few minutes more to watch this information.
Many thnaks for the tips!
|
|
Dick Rosenberg on 12/29/2008
Why is this important?
|
|
Carla Wilson on 12/29/2008
Thanks for clarifying the concept of setting up proxies. We recently had to set up a proxy in order to schedule certain SSIS packages. It seemed like an unnecessary step at first, but I do appreciate it now. I didn't know you could go back to the proxy properties and see what jobs are using it.
|
|
Craig Pessano on 12/29/2008
I've set up proxy accounts to run SSIS packages from non-sysadmin accounts. This was a great explanation of how the logins and proxies work together. Thanks!
|
|
|
great explanation!
|
|
|
would like to have seen how this might have worked accross servers too, i.e. linked server job.
|
|
|
In just 5 minutes i learned how to constructively trigger SQL Agent Jobs securely via a proxy.
I have personally been reading Google forums and trying to find out this information for some time now. Normal text based tutes are sometimes tricky to work out. This blew them all away!
I have only one question about the TestLogin user? Does it need to be attached as a user in the MSDB database when running an Agent Job specific to a Database?
|
|
|
good topic and very easy to understand.
|
|
|
A little too fast, otherwise excellent!
|
|
|
Great Video. Few suggestions
1. Wish you had shown a MATRIX first of 4 things that you demoed, that will explain better
2. Displaying a DATA-FLOW Diagram can be helpful, provided you define the dependencies & pre-requisites
May be I'm asking for too much, but they say "Picture Speaks 1000+ words"
|
|
|
Very Informative. And expects more details about proxy account.
|
|
|
|
|
|
|