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 are the extra roles available in msdb? : sql server security

0 Answers  

What is an index?

8 Answers   Yardi Software,

What happens to a statement batch if there is a compilation error?

0 Answers  

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

Can we insert data into a view?

0 Answers  

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

What is candidate key with example?

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

Explain what are the database objects? : SQL Server Architecture

0 Answers  

Can two tables share a primary key?

0 Answers  

What is temporary stored procedure?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories