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 kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

Explain about protocol layer present in SQL server?

0 Answers  

How will u get 5 years back record?

5 Answers  

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

How do I setup a sql server database?

0 Answers  

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

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

0 Answers  

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

What is cube dimension? : sql server analysis services, ssas

0 Answers  

What is the use of custom fields in report?

0 Answers  

What is normalization? What number of normalization shapes are there?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories