what is integrated security (SSPI). why we use in the connection string?

what is integrated security (SSPI). why we use in the
connection string?

Question Posted / thiru..

2 Answers
6348 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is integrated security (SSPI). why we use in the connection string?..

Answer / oliva

Actually If we specified a username & pwd

in connection string and we are using

Integrated Security=SSPI ...

Is This Answer Correct ?

4 Yes

2 No

what is integrated security (SSPI). why we use in the connection string?..

Answer / 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

More SQL Server Interview Questions

Explain trigger classes i.e. Instead of and after trigger?

0 Answers

Tell me what are cursors and when they are useful?

0 Answers

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers AllState,

What happens if an integer is too big for int date type?

0 Answers

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers United Healthcare,

How to end a stored procedure properly in ms sql server?

0 Answers

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers Genpact,

Explain what is the function of sql server agent windows service?