Wednesday, May 28, 2008
Sunday, May 25, 2008
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
Posted by Madhu K Nair at 8:41 PM