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
What is the maximum size of a row in sql server?
What are Spatial data types in SQL Server 2008
Define indexes?
What the difference between UNION and UNIONALL?
What is the sql case statement used for? Explain with an example?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is the function of inner join?
What is a coalesce function?
what's the difference between a primary key and a unique key? : Sql server database administration
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Define outer join?
Can an entity have two primary keys?
How to download and install microsoft sql server management studio express?