Ola!!
I have a database that is connecting to an SQL server/database using LotusScript. The datasource is a DSN type connection with username & password authenticating using login ID and password entered by user. User/password is also specified in the code.
For the most part, when the scheduled agent runs, it processes the data ok, then every once in a while, maybe once a week or every other week, the agent will hang. When I log into the windows machine, I notice an MS SQL server login error saying the server does not exist or access denied. If I click ok on that, another login box pops up with the ODBC datasource user name and password already in the fields. I click ok, and then the agent starts to process as normal.
When this occures, I also find the following TCIP memory errors in the log…
05/03/2005 07:45:47 AM Error connecting to server NCIAPP01/NCI: The TCP/IP protocol stack reported that it ran out of memory. Consult your network documentation to increase configured memory, or reduce Notes connections by limiting clients (see SERVER_MAXSESSIONS parameter in …
The SQL admin says that everything looks good on his server. Why would the agent run fine, and then one day stop because it wants a manual log in??