WHAT IS CREDENTIAL – SQL SERVER
Posted on : 05-07-2011 | By : Devi Prasad | In : Credentials, SQLServerPedia Syndication
0

WHAT IS SQL SERVER CREDENTIAL?
SQL Server credential stores the authentication information which is required to access a resource.
Credentials store the following details:
- Credential Name – Name of the credential, this is used for refereceing the credential
- Identity – This is basically the username
- Password – Password of the identity/username.
- Encryption Provider – Authentication details can be encrypted using this option.
Basic Example:
[sql]
USE [master]
GO
CREATE CREDENTIAL [credential1] WITH IDENTITY = N’username’, SECRET = N’password’
GO
[/sql]
In the above example Credential1 is created with identity :username and password : password
The created credentials can be used in agent proxies
Reference : Devi Prasad (sqlserverlearner.com)
Do you like my blog?
If you liked reading this blog, please help spread the word by sharing this blog with your friends.
Need Help On SQL Server?
Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.

Tags: example of credential, uses of credentials, what are sql server credentials, why credential