Hi,
I am writing a webpage using asp.net (c#) and setting up a webserver
using ISS 5. The web form is accessing an MSSQL2005 database on another
box, using windows authentication login.
The connection string is:
"Data Source=aaaaa;Initial Catalog=DevTrackIssues;Integrated Security=SSPI;"
My ISS is set to not allow anonymous users and use Windows authentication in "Directory security". But if the aspx page is accessed from other box with a different windows logon, the mssql connection authentication fails because it doesn't get the client windows logon.
I tried to use the impersonate:
I was able to let the clients get access to Mssql server by forcing
them to enter their windows authentication. (checked the "Basic
authentication" option in IIS setting, but no others.) But it is obviously not the right solution.
What I want ...
Go to the complete details ...