Online Documentation for SQL Administrator for SQL Server

Credentials


A Credential is a record containing the authentication information required to connect to a resource outside of SQL Server. Most credentials consist of a Windows login and password.

Credentials allow users that connect to SQL Server using SQL Authentication to connect to Windows or other resources outside of SQL Server.

After creating a credential, you can map it to a login. A single credential can be mapped to multiple SQL Server logins. But a SQL Server login can be mapped to only one credential.

 

Credentials are used for accessing the Windows Azure storage for uploading backup files.

 

Use the context menu to:

Create create a new credential

Edit edit the selected credential(s)

Drop drop the selected credential(s)

  • rename the selected login
  • create the object copy on the same server
  • clone the object copy to another server

Print create and print the report

 

Alternatively, you can use the 'Insert' button to create a credential, 'Enter' button to edit credential(s) and 'Delete' button to drop credential(s).

 

Security - Credentials

 

 

The list displays the existing server credentials as a grid with the following columns: Name, Identity, Creation Date, Modification Date, Target Type. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find operations that can be performed with the grid.

 

To open a Credential in the Credential Editor, double-click it in the grid. Alternatively, you can right-click the Credential alias and select the Edit context menu item.