| haluser 2004-03-18, 3:34 pm |
| I'm installing the BT2002 with HIPAA accelerator and BT adapter for SQL server to generate 835 file on a server (TESTSERVER) where the SQL server is located on another box. So the interchangeDTA, BTM, SQ, XLANG, etc databases are not in the TESTSERVER. I have no problem generating 997 and 837 HIPAA files. However, when it comes to generating 835 right after i start the SQL Adapter job, I got the error message below. I use the domain administrator account which also belongs to the local administrator group and can access the SQL server on the other box as well.
On the case where the BTS2002 and SQL server are on the same box, I have no problem at all. One time I got the same error on this scenario (BTS and SQL on the same box). I fixed it because the SQL SERVER AGENT was not started.
Event Type: Error
Event Source: RFSQL
Event Category: None
Event ID: 10
Date: 3/17/2004
Time: 4:12:44 PM
User: N/A
Computer: TESTSERVER
Description:
A worker thread reported a failure: The server process could not be started because the configured identity is incorrect. Check the username and password.
The error code is shown in the data area below.
The operation was: ISQLWorker->Execute
The worker thread was working on:
Job Name: Job 1
SQL Script: Exec [sp_getclaim]
Data:
0000: 1a 40 00 80
Any idea why this happened? |