what is integrated security (SSPI). why we use in the
connection string?
Answer Posted / ankur negi
If your application runs on a Windows-based intranet, you
might be able to use Windows integrated authentication for
database access. Integrated security uses the current
Windows identity established on the operating system thread
to access the SQL Server database. You can then map the
Windows identity to a SQL Server database and permissions.
To connect to SQL Server using Windows integrated
authentication, you must identify the Windows identity under
which your ASP.NET application is running. You must also be
sure that the identity has been granted access to the SQL
Server database. This topic includes a code example that
displays the current Windows identity of the ASP.NET
application.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
We need to perform what steps in the following order to work with a cursor?
Differentiate between mongodb vs. Sql server?
Explain how dts is used to extract, transform and consolidate data?
What is de-normalization and what are some of the examples of it?
What is a benefit of using an after insert trigger over using a before insert trigger?
What is not null constraint?
Tell me about joins in database system and explain each in detail.
Mention the different types of triggers?
What is a mutating table error and how can you get around it?
How do I edit a procedure in sql server?
Can multiple columns be used in sql group by clause in ms sql server?
What happens when the SQL Azure database reaches Max Size?
What is reportserver and reportservertempdb ?
Why do you want to join software field as you have done your BE in Electronics?
When you use @@error and try-catch?