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
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Explain the purpose of indexes?
Can you force a query to use a specific index?
how you can list all the tables in a database?
What is spatial and temporal data?
What the different components in replication and what is their use?
How to get a list all databases on the sql server?
What stored procedure can you use to display the current processes?
Tell me what are cursors and when they are useful?
How can sql server instances be hidden? : sql server security
What is log ldf?
What are window functions in sql server?
What is factless fact table? : sql server analysis services, ssas
When a primary key constraint is included in a table, what other constraints does this imply?
What is sql or structured query language?