IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact
You are here: Home / Database / How to Create a SQL Server Agent Proxy Account

How to Create a SQL Server Agent Proxy Account

When you need to execute job steps under a specific security context, proxy account can be used to allow users who are not sysadmin to run them.

Before you can create a proxy account, you first need to create a credential that needs to be linked later. This can be a window service account or a user’s active directory id.

Creating a Credential

  1. In the Object Explorer, expand Security node
  2. Right-click Credentials node and select New Credential
  3. After giving a name to the credential, enter a Windows account and the password

SQL Server Adding a New Credential

Creating a Proxy

  1. Back in the Object Explorer, expand the SQL Server Agent node
  2. Right-click Proxies and select New Proxy Account
  3. You can use the same proxy name as your credential
  4. Select any subsystems you want to enable for the particular proxy

SQL Server Agent - Adding a New Proxy Account

In this example the proxy was created to run SSIS packages, so SQL Server Integration Services Package was checked. That’s all there is to it.

Further Reading

SQL Server 2016 High Availability Unleashed cover image More detailed information can be read from “SQL Server Agent Proxy Account” section from the following book:
SQL Server 2016 High Availability Unleashed

February 6, 2014 Filed Under: Database Tagged With: Microsoft SQL Server, Proxy Account, Server Agent, SQL Server

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication
  • RSS

Tags

.NET Access AdSense ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack Linux macOS Microsoft Microsoft SQL Server MVC PHP Python Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Windows Windows 8 Windows 10 Windows Server

Copyright © 2011-2022 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure