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

what is checksum in sql server.........???

0 Answers   TCS,

If no size is defined while creating the database, what size will the database have?

0 Answers  

What is a partition key?

0 Answers  

How many categories of data types used by sql server?

0 Answers  

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  




How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

What are the main sources of data?

0 Answers  

What is a function? Give some example?

3 Answers  

Psudo colums

1 Answers   HP,

What is an Index?

3 Answers   Yardi Software,

How to get the definition of a stored procedure back?

0 Answers  

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

For more SQL Server Interview Questions Click Here
Categories