Integrated Security

[Srinivasa Reddy K Ganji]

Hi

I have come across this type of code at many places.

New SqlConnection("Data Source=(local);Initial Catalog=XYZ;Integrated
Security=SSPI;")

I assume that the database connection details are hidden here. What is
"Integrated Security=SSPI"? Can anyone guide me how to set this up using c#.
Also is it possible to set up this type of connections on web sites hosted
with commercial web hosting companies. Any examples, links highly
appreciated.

Thanks in advance,

Reddy

 

[S. Justin Gengo]

Integrated security mean that the connection to the sql server will be made
using the currently logged in user's credentials.

Here's a good article on how to use integrated security:

http://msdn.microsoft.com/library/d...singSQLServerUsingMappedWindowsDomainUser.asp

Sincerely,

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche