Sign Up Login


  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 change the ownership of a schema in ms sql server?

0 Answers  

what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,

Define outer join in sql server joins?

0 Answers  

What is outer join in sql server joins?

0 Answers  

How do I clean up sql server transaction log?

0 Answers  




List some of the rules that apply to creating and using a ‘view’

0 Answers  

Where cross join is used?

0 Answers  

What are different types of replication in sql server?

0 Answers  

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

What is Lock table in SQL?

0 Answers   Wipro,

How can I create a table from another table without copying any values from the old table?

3 Answers  

What is transaction server distributed transaction?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories