SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

MS SQL Maestro online Help

Credentials allow users that connect to Microsoft SQL Server using SQL Authentication to connect to Windows or other resources outside of SQL Server. A credential is a record containing the authentication information needed to connect to a resource outside of SQL Server. Most credentials consist of a Windows user login name and password. In Windows 2003 Server and above, the password may not be required. This server object is available since Microsoft SQL 2005.

After creating a credential, you can map it to a SQL Server login with Create Login Wizard or Login Editor.

Note: A single credential can be mapped to multiple SQL Server logins. But a SQL Server login can be mapped to only one credential.

New credentials are created within Create Credential Wizard. In order to run this wizard you should either

•	select the Credentials list or any object from that list and then use the Create New Credential item from the popup menu

•	open the server in Server Editor and the Credentials tab there and press Insert or select the Create New Credential item from the popup menu (Alternatively, use the corresponding link of the Navigation Bar).

Credentials are edited within Credential Editor. In order to open the editor you should either

•	select the credential for editing in the explorer tree (type the first letters of the credential name for quick search);

•	select the Edit Credential item from the popup menu

•	open the server in Server Editor and the Credentials tab there;

•	select the credential to edit;

•	press the Enter key or select the Edit Credential item from the popup menu (alternatively, you can use the corresponding link of the Navigation Bar).

To drop the existing credential:

•	select the credential to drop in the explorer tree;

•	select the Drop Credential item from the popup menu

•	open the server in Server Editor and the Credentials tab there;

•	select the credential to drop;

•	press Delete or select the Drop Credential item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.