ASP page needs to connect to an SQL under a different user context

[FengShui1998]

Hello,

I have an ASP page that used to connect to an SQL database with an SQL login.
For security purposes, they have disabled the SQL logins and now they are requiring a domain login.

Now I can't run an query with the SQL login. Is there a way I can spoof a domain\username to the SQL database from an ASP page?

Thanks ahead?
fengshui1998

 

[gmmastros]

I don't think there is any way to "spoof" a domain\user with ASP, at least... I hope there's not a way.

IIS has a domain\username that it uses for permissions. This is the domain\username that is passed to SQL Server when you use windows authentication.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom