Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / thiru..

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

How to return the second 5 rows in ms sql server?

0 Answers  

How do you find the number of rows in a table?

7 Answers  

What are cursors in ms sql server?

0 Answers  

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

what is database replicaion? : Sql server database administration

0 Answers  

How to delete an existing database user?

0 Answers  

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

What is shrink log file?

0 Answers  

Explain following error properties?

0 Answers  

what is IDE,DMV in sql server?

1 Answers   Value Labs,

Differentiate between truncate vs delete in mssql?

0 Answers  

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

For more SQL Server Interview Questions Click Here
Categories