V
VT
Hello ,
I am trying to solve pretty straight forward and typical task and yet have
difficulties. Can someone help ? I cannot believe this has not been solved
by someone already.
I have simple ASP.NET intranet app which is supposed to record user's
windows username into the SQL database.
Database administrators granted permissions to single dedicated windows
account to read/write the db and enforced the rule that only windows
authentication to SQL db is allowed.
Now comes the problem:
If I enable anonymous access in IIS and put that dedicated account on, I can
read/write SQL db, but userid detected by my ASP code is always blank.
If I disable anonymous access, then userid is not blank, but I cannot
read/write SQL db because only dedicated account has permissions, not users
themselves.
What I really need is both: ability to programmatically detect username and
ability to use windows authentication with SQL db.
Any ideas ?
Thanks
VT
I am trying to solve pretty straight forward and typical task and yet have
difficulties. Can someone help ? I cannot believe this has not been solved
by someone already.
I have simple ASP.NET intranet app which is supposed to record user's
windows username into the SQL database.
Database administrators granted permissions to single dedicated windows
account to read/write the db and enforced the rule that only windows
authentication to SQL db is allowed.
Now comes the problem:
If I enable anonymous access in IIS and put that dedicated account on, I can
read/write SQL db, but userid detected by my ASP code is always blank.
If I disable anonymous access, then userid is not blank, but I cannot
read/write SQL db because only dedicated account has permissions, not users
themselves.
What I really need is both: ability to programmatically detect username and
ability to use windows authentication with SQL db.
Any ideas ?
Thanks
VT