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.




Your Ad Here


Tags: , , ,