none
Question about SQL Server 2005 Agent Proxies?

    Question

  • Hi, all experts here,

    Can please anyone here give me any idea about SQL Server 2005 Agent Proxies? What are they? What are they for? When should be a good practice to use them?

    Thanks alot in advance for your kind help and I am looking forward to hearing from you.

    Best regards,

    Yours sincerely,

     

    Thursday, August 28, 2008 1:44 PM

Answers

  • Hi,

     

    when a user wanted to execute a SQL Server Integration Services (SSIS) package as a job step, the sysadmin had to enable the SQL Server Agent proxy account. After the account was enabled, any SQL Server Agent user could create job steps for certain subsystems, such as CmdExec, and run them by using this account. In SQL Server 2005, SQL Server Agent addresses this security concern by using multiple proxy accounts.

    http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx

     

    And also...

     

    SQL Server can operate transparently with Proxy Server to prevent unauthorized access to your internal network. By using this configuration, you do not have to connect the computer running SQL Server directly to the Internet.

    When you run SQL Server on a computer located behind Proxy Server, SQL Server is protected by the packet filtering features of Proxy Server. You can configure Proxy Server to permit or deny inbound SQL Server access to specific users, services, ports, and IP domains

     

    http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx

     

    BR
    Praveen Barath

     

    Mark as answer if it helps

    Thursday, August 28, 2008 2:15 PM

All replies

  • Hi,

     

    when a user wanted to execute a SQL Server Integration Services (SSIS) package as a job step, the sysadmin had to enable the SQL Server Agent proxy account. After the account was enabled, any SQL Server Agent user could create job steps for certain subsystems, such as CmdExec, and run them by using this account. In SQL Server 2005, SQL Server Agent addresses this security concern by using multiple proxy accounts.

    http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx

     

    And also...

     

    SQL Server can operate transparently with Proxy Server to prevent unauthorized access to your internal network. By using this configuration, you do not have to connect the computer running SQL Server directly to the Internet.

    When you run SQL Server on a computer located behind Proxy Server, SQL Server is protected by the packet filtering features of Proxy Server. You can configure Proxy Server to permit or deny inbound SQL Server access to specific users, services, ports, and IP domains

     

    http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx

     

    BR
    Praveen Barath

     

    Mark as answer if it helps

    Thursday, August 28, 2008 2:15 PM
  • Hi,

    Thanks a lot for your help. That's been very helpful.

    Best regards,

    Yours sincerely,

     

    Thursday, August 28, 2008 2:42 PM