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


Please Help Members By Posting Answers For Below Questions

Explain a join?

700


When is the use of update_statistics command?

639


What are binary string data types in ms sql server?

736


what is isolation level at dead lock?

1841


Tell me about joins in database system and explain each in detail.

696






Explain what are magic tables in sql server?

614


ow to bring suspect mode datbase online from scratch

1497


What is the difference RDBMS and Graph Database?

705


What the different types of Replication and why are they used?

631


how can a database be repaired? : Sql server administration

591


What are key constraints?

600


What are the advantages of the mirroring?

669


Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

638


What are the tool windows in sql server management studio? : sql server management studio

707


How to verify the port number of the sql server?

618