SQL Security Mode from an application

[johnaregan]

Hi
The Security mode on my SQL Server 6.5 is set to Standard Security Mode. I have read in MSDN that you can override this from an applicatoin by explicitly requesting integrated security over trusted connections. So that for just a once off you can choose Mixed or NT Integrated.
My question is how do I do this from an application? I am using ASP.
The link below is the page where I read this, scroll down to Login Security and read the 'Standard Security Mode' section.

thanks in advance
John

http://msdn.microsoft.com/library/d...ry/en-us/dnproasp/html/securitydataaccess.asp

 

[jantie78]

You must give the account that your IIS runs access to you SQLServer. The user that IIS uses is something like IWAM_USER. If this response was usefull to you, please mark it with a Star!