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
Is null in sql server?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Will count(column) include columns with null values in its count?
What are the advantages of policy management?
Do you know what is similarity and difference between truncate and delete in sql?
What are drillthrough reports?
How to use values from other tables in update statements in ms sql server?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is a non-clustered index?
What are the different methods available under sqlcommand class to access the data?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
what are triggers? : Sql server database administration
Tell me what is a linked server?
How do I open a .db file?
how would you improve etl (extract, transform, load) throughput?