I have some code in an agent that is called on the WebQueryOpen of a form. This code connects to a MS-SQL database to get values from a table and populate a field on the form.
I use the LSXLC to connect to the OLE DB. In my code, I supply the username and the password needed to connect to SQL. All works fine if I run the same code on the Notes client, but on the web, I get this error:
Error 12325 on line 38 in function INITIALIZE: Error:
ErrorRecord: HResult: 0x80040e4d
Description: Login failed for user ‘ADDomain\ADServerID’.
SQLErrorInfo: 42000
(ADDomain\ADServerID is our server’s Active Directory account doomain\name).
How come the server wants to log on the SQL machine? I used totally different credentials in my code: I used a different user/password than that!!!
Quite puzzling…
Thanks to anyone who can help