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
what is raid? : Sql server database administration
How to perform key word search in tables?
How to replace given values with null using nullif()?
Explain full-text query in sql server?
Give the query of getting last two records from the table in SQL SERVER?
How to create a Master database in SQL server ?
What is 1nf normalization form?
How many partitions a clustered index has by default in sql server 2012?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is lookup override?
What are the pre-defined functions in the sql server?
How do you trace the traffic hitting a sql server?
How to compare the top two records using sql?
What do you understand by the data quality services in sql server?
What is an index in a database?