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 delete existing triggers using "drop trigger"?

0 Answers  

What is the function of sql server agent windows service?

0 Answers  

How to delete a database in ms sql server?

0 Answers  

What is inline table-value user-defined function?

0 Answers  

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

what are user defined datatypes? : Sql server database administration

0 Answers  

How to create indexed view?

0 Answers  

What gets stored inside msdb database?

0 Answers   Abacus,

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

What are the differences between stored procedure and the dynamic sql?

0 Answers  

How to search for a string in all stored procedure in sql server?

0 Answers  

How to make a column nullable?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories