{"id":43,"date":"2011-07-05T12:46:34","date_gmt":"2011-07-05T12:46:34","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/07\/05\/subsystems-of-proxies\/"},"modified":"2011-07-05T12:46:34","modified_gmt":"2011-07-05T12:46:34","slug":"subsystems-of-proxies","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/07\/05\/subsystems-of-proxies\/","title":{"rendered":"SUBSYSTEMS OF PROXIES &#8211; SQL SERVER"},"content":{"rendered":"<p><strong>SUBSYSTEMS OF SQL SERVER PROXIES <\/strong><\/p>\n<p>Following are the different subsystems of SQL Server Proxies:<\/p>\n<ul>\n<li>ActiveX Script<\/li>\n<li>Operating System (cmdExec)<\/li>\n<li>Replication Distributor<\/li>\n<li>Replication Merge<\/li>\n<li>Replication Queue Reader<\/li>\n<li>Replication Snapshot<\/li>\n<li>Replication Transaction-Log Reader<\/li>\n<li>SQL Server Analysis Services Command<\/li>\n<li>SQL Services Analysis Services Query<\/li>\n<li>SQL Server Integration Services Package<\/li>\n<li>Power Shell<\/li>\n<\/ul>\n<p>Why so many subsystems?<\/p>\n<p>SQL Server Proxies are mainly used to impersonate different users authentication for a job step.<br \/>\nSo if we open the a job step we find the same subsystems shown above as types.<\/p>\n<p>Below are the screen shots that explain in more detail.<\/p>\n<p>New Proxy &#8211; Sub Categories:<\/p>\n<figure id=\"attachment_407\" aria-describedby=\"caption-attachment-407\" style=\"width: 259px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2011\/07\/New-Proxy-e1309875964337.png\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/07\/New-Proxy-e1309875964337-259x300.png\" alt=\"New Proxy\" title=\"New Proxy\" width=\"259\" height=\"300\" class=\"size-medium wp-image-407\"><\/a><figcaption id=\"caption-attachment-407\" class=\"wp-caption-text\">New Proxy - Sub Categories<\/figcaption><\/figure>\n<p>New Job Step &#8211; Types:<\/p>\n<figure id=\"attachment_408\" aria-describedby=\"caption-attachment-408\" style=\"width: 258px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2011\/07\/New-Job-Step-e1309875854770.png\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/07\/New-Job-Step-e1309875854770-258x300.png\" alt=\"New Job Step\" title=\"New Job Step\" width=\"258\" height=\"300\" class=\"size-medium wp-image-408\"><\/a><figcaption id=\"caption-attachment-408\" class=\"wp-caption-text\">New Job Step - Types<\/figcaption><\/figure>\n<p>Hence the Subcategories in Proxies are related to Job types in Jobs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SUBSYSTEMS OF SQL SERVER PROXIES Following are the different subsystems of SQL Server Proxies: ActiveX Script Operating System (cmdExec) Replication Distributor Replication Merge Replication Queue Reader Replication Snapshot Replication Transaction-Log Reader SQL Server Analysis Services Command SQL Services Analysis Services Query SQL Server Integration Services Package Power Shell Why so many subsystems? SQL Server Proxies&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[106],"tags":[119,120,121],"class_list":["post-43","post","type-post","status-publish","format-standard","hentry","category-proxies","tag-use-of-subsystem-in-proxy","tag-what-are-subsystems-sql-server-proxy","tag-why-so-many-subsystems-in-sql-server-proxy"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/43\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}