1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

any one can explain
Self mapping
Delegation
Remote Credentials

Question Posted / laxman


any one can explain Self mapping Delegation Remote Credentials..

Answer / 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

More SQL Server Interview Questions

How to check parameter value in stored procedure sql server?

0 Answers  

What is sql server used for?

0 Answers  

What samples and sample databases are provided by microsoft?

0 Answers  

How can I enforce to use particular index?

1 Answers   Symphony,

Explain external key management in sql server 2008

0 Answers  




What is the purpose of using COLLATE in a query?

1 Answers  

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

How do you persist objects, permissions in tempdb

1 Answers  

why would you use sql agent? : Sql server database administration

0 Answers  

What is use of except clause?

0 Answers  

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

What does nvl stand for?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories