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

Subscribe to our news:
Partners
Testimonials
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".
Kevin Settler: "If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".

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