Hi All,
I have a web site that is using Windows Authentication for logging in as well as connection to SQL. My site has some ActiveX components on the server that it calls which also does some SQL connections, queries, etc. The problem I'm having is when the ActiveX is called it cannot connect to the Sql Server - I get an error saying 'Login failed for user 'Domain\MachineName$. I have impersonate = true in the web.config. I would have thought that since it is the asp.net process calling the activex dll that the dll would run under the same windows account as the .net process currently is. Is this not the case and is there a way to make it do so in order that the windows credentials are used in the ActiveX when connecting to Sql Server?
Thanks!
...
Go to the complete details ...