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

Subscribe to our news:
Partners
Testimonials
Paolo Benjamin T. Briones: "I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".
Jim Salmons: "That is excellent news! I will look forward to a future update with these features. It will be attention to such details that further distinguishes your excellent products from the competition.

As always, I appreciate your great products and your demonstrated customer service is equal to the high quality of your products".

More

Add your opinion

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