Hey guys, I have a scenario which I'm sure isn't that common; I can't really find any help with a Google search.
We have some old back office apps, and a 3rd party vendor supplied us with a COM object for credit card processing to integrate with our back office. This COM object uses ADO and an OLEDB connection string to connect to a SQL server. The SQL connection is using Windows Integrated Security.
Everything works fine from our ASP.NET apps when running under the visual studio web server; however it falls apart as soon as we hit our beta servers.
When we attempt to call into the COM object, we get:
System.Runtime.InteropServices.COMException: Login failed for user 'DOMAIN\COMPUTERNAME$'.
(I replaced the domain and computer name for readability)
In IIS, the website is running with a user specified for anonymous browsing. That username is automatically used when we call the SQL DB directly b ...
Go to the complete details ...