Running SQL Server Jobs using a Proxy Account

6) As ‘testlogin’ has sufficient privileges, we can
consider creating the proxy. As the requirement is to run a SQL Server job
which is of type ‘SQL Server Integration Services Package’, we need to create
the proxy account under the ‘SSIS Package Execution’ subsystem folder as shown
below:

In the next window, enter appropriate proxy account name and
map it to the credential which was created in step (4). Check the appropriate
subsystem checkbox. In this case, it is SQL Server Integration Services Package.

In the ‘Principals’ option, select the ‘testlogin
SQL login which was created in step (2).

7) This is an important step. Here, we need to assign the
job step to run under the new proxy account created. For this, we need to go
back to the job step as in step (5) and change this job step to run using the ‘testloginproxy
account.

8) Finally test the proxy has been setup up correctly by connecting
to the SQL Server instance using the ‘testlogin’ sql login. Go to the maintenance
plan job ‘Maintenancetest.Subplan_1’ under SQL Server Agent and start
the job. The  job should succeed using the credentials and proxy account which
we created earlier.

Pages: 1 2




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |