Using other instead of aspnet account for trusted connection

[Wilson]

Hi,

How to set the web form to use others account instead of aspnet under trusted connection for SQL server ?

Thanks in advance
Wilson

 

[Paul Clement]

¤ Hi,
¤
¤ How to set the web form to use others account instead of aspnet under trusted connection for SQL server ?

If you are using integrated Windows NT security with ASP.NET you have to enable impersonation:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconImpersonation.asp

You also need to include Integrated Security=SSPI in your SQL Server connection string.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)