Sunday, May 25, 2008

SQL Server 2008 - Credential a New property for a SQL login

While creating login you can set a new property called Credential. This Property asks SQL Server Engine to use this credential (which is in-tern mapped to a windows user ) to interact outside SQL Server. Earlier all the interaction with OS or outside sql server was done using Service Account. Now you can specify which windows user credential to be used for a specific login.

Steps are as follows

(a) Create Credential

CREATE CREDENTIAL credential_name WITH IDENTITY = 'identity_name'
[ , SECRET = 'secret' ]
[ FOR CRYPTOGRAPHIC_PROVIDER cryptographic_provider_name ]

Create Credential using Management Studio

(b) Create Login and specifiy Credential

CREATE LOGIN NewLogingName WITH PASSWORD = 'Password',
CREDENTIAL = NewCredentialName