Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › Define a Credential in SQL Server

Define a Credential in SQL Server

Use the SQL Server Credential Editor to define the authentication information required for a resource that is outside of SQL Server in a SQL Server 2008 or 2012 physical model. Most credentials include a Windows user name and password, which are mapped to a login.

To define a credential in SQL Server

1. Click Target - SQL Server, Security, Credentials on the Model menu.

   The SQL Server Credential Editor opens.

2. Select the credential in the Navigation Grid that you want to define and enter a value for the following field:

   Note: Click New on the toolbar to create a new credential. Use the Enter filter text box to filter a very large list of credentials to quickly locate the one that you want to define.

   Name

   Displays the credential name. You can change the credential name in this field.

   Identity

   Defines the name of the account used when connecting outside the server. Use in-place editing to enter or change the value.

   Cryptographic Provider

   Defines the extensible key management provider used by the credential.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. (Optional) Click the Comment tab and enter any comments that you want to associate with the credential.
4. (Optional) Click the Where Used tab to view where the credential is used in the model.
5. (Optional) Click the UDP tab to work with user-defined properties for the credential.
6. (Optional) Click the Notes tab to view history information and view or edit user notes.
7. Click Close.

   The credential is defined and the SQL Server Credential Editor closes.