any one can explain
Self mapping
Delegation
Remote Credentials
Answer Posted / debapriya
These are the three different security model connecting to
Linked Server.
In Self Mapping SQL Server tries to connect to the linked
server using current users credentials(UserId and PWD).
In Delegation SQL Server tries to connect to the Linked
server by using the Windows credential.
In Remote Credentials the Local login credential is mapped
into remote credential.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we can refresh the view?
How does normalization work?
What are the different types of backups avaialabe in sql server 2005?
How to enable/disable indexes?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is transaction server explicit transaction?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is built-in function?
How many instances per computer are there in sql server 2000?
Explain the etl (extraction, transformation, and loading)?
What is an identity column in insert statements?
What does the on update no action do?
How can you start sql server in different modes?
What is optimistic concurrency?
What are alternate keys?