Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 122

For more information on SQL Server agent services refer to the
Designing automated administration practices recipe mentioned in
Chapter 2 , Administration of core database engine .
This will provide a trusted authentication identity for the tasks within SQL Server as well as a
Windows identity for tasks outside SQL Server. Since this is a security object, you will create
the credential from the security section in the Object Explorer of the SSMS.
How to do it...
To begin implementing security for SQL Server Agent Jobs, let us go through the required
steps to create a credential as follows:
1. Open the SQL Server Management Studio and connect to the SQL Server instance.
2. Locate the Security node in the Object Explorer. Expand the node and locate the
Credentials node inside.
3. Right-click the Credentials node and select New Credential from the menu. Provide
a name for your credential in the CredentialName text box.
4. Enter the name of the Windows account that you wish to map in the Identity
text box.
5. Enter and confirm the password of the Windows account (as shown in the next
screenshot). The system will use this password when it attempts to authenticate
under this identity.