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 are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Explain collation?
what is a deadlock? : Sql server database administration
What is difference between temp table and cte?
Explain what are the events recorded in a transaction log?
How to restore performance issues and how to check?
How to create stored procedures with parameters in ms sql server?
What is the purpose of the tempdb database?
What is database replication?
What are the different subsets of sql?
What does <> symbol mean?
What is the cartesian product of table?
What are the new features of sql server 2008 r2 reporting service?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Mention what are the core components of ssrs?