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 the largest component inside a field?
What are the advantages of using a stored procedure?
If no size is defined while creating the database, what size will the database have?
What is transaction server auto commit?
What are the different acid properties?
what are different types of backups available in sql server? : Sql server database administration
What is difference between joins and subqueries?
Difference between uniqe index and uniqe constraint?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How do we Backup SQL Azure Data?
Explain datetime2 data type in sal server 2008?
Define full outer join?
What is db stored procedure?
Can a table be moved to different filegroup?
What is a user-defined function in the sql server and what is its advantage?