Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
DavidNR: "MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".
Tracy J Powell: "Thank you VERY much for the quick and helpful response. I will definitely upgrade as soon as possible. Your products are great and I use them daily".

More

Add your opinion

Customers
Download Buy

MS SQL Maestro online Help

Prev Return to chapter overview Next

Credentials

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

or

•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

or

•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

or

•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.

 


Prev Return to chapter overview Next