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

What is difference between materialized view and view?

0 Answers  

What is hot add cpu in sql server 2008?

0 Answers  

What is an example of a primary key?

0 Answers  

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

What the difference between UNION and UNIONALL?

0 Answers   HCL,

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

What will be query used to get the list of triggers in a database?

0 Answers  

Explain try...catch with sql server?

0 Answers  

Why olap is used?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories