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
I belong to a small village called Cherumundasseri in Pallakkad District of Kerala,India the “Gods Own Country”. I am proud for being an Ex-Sailor from prestigious service of Indian Navy. I owe to Navy for giving me a world class training and a platform to apply my knowledge.