You are the database administrator of your company. The network contains a SQL Server 2008 computer named SQL1.
You are in the process of creating a SQL Server Agent job that will use an ActiveX script to monitordatabase file sizes.
To ensure that the job runs successfully, you want to configure the job step to use a proxy account that haspermission for the ActiveX Script subsystem of the SQL Server Agent.
To achieve this, you want to create a proxyaccount for the job step. What must you do before creating a proxy account?
A.
Create a new operator.
B.
Create a new SQL login.
C.
Create a credential.
D.
Create a non-administrative local user account.
Explanation:
You should create a credential. By default, every job step runs under a specific security context. If you configure aproxy account for a job step, the job step runs under the security context of the proxy’s credentials. If you do notconfigure a proxy account for a job step, the job step runs under the security context of the SQL Server Agentservice account. However, you should configure a proxy account with appropriate permission for the respectiveSQL Server Agent subsystem when creating job steps that use ActiveX scripts, PowerShell scripts, and operatingsystem commands, as shown in the following graphic:
If the proxy account does not have permission for the appropriate subsystem, the job step may not runsuccessfully. To be able to create a proxy account, you must have at least one credential created that will be usedby the proxy account. A credential is a record that contains the authentication information required to connect to aresource outside of SQL Server.
You should not create a new operator because that is not required by a proxy account. SQL Server operators are used to receive alert and job status notification in response to events generated by the server. You should not create a new SQL login or a non-administrative local user account because these are not requiredby a proxy account. A proxy account requires a credential. A SQL login or a non-administrative local user accountmay be used to create a credential, but these cannot be directly specified in a proxy account. A proxy accountrequires a credential.Objective:
Maintaining SQL Server InstancesSub-Objective:
Manage SQL Server Agent jobs.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administration: How-to Topics > Automated Administration How-to Topics (SQL Server Management Studio) >How to: Create a Proxy (SQL Server Management Studio) MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administration: How-to Topics > Server Management How-to Topics > SQL Server Management Studio How-toTopics > How to: Create a Credential (SQL Server Management Studio) TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administration: How-to Topics > Automated Administration How-to Topics (SQL Server Management Studio) >How to: Create an ActiveX Script Job Step (SQL Server Management Studio)
