what is integrated security (SSPI). why we use in the
connection string?
- 2 Answers
- 6371 Views
- I also Faced
- E-Mail Answers
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
explain different types of constraints? : Sql server database administration
How to find which stored procedure is currently running in sql server?
What is meant by Active-Passive and Active-Active clustering setup?
Determine when to use stored procedure to complete sql server tasks?
What does the on update no action do?
What is row_number function?
What are the key configuration files for sql server reporting services ?
In what three ways is the return statement used in a stored procedure?
what are acid properties? : Sql server database administration
What is an indice?
what is raid? : Sql server database administration
What happens when transaction log is full?
What new data source types were added in ssrs 2014?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
