I'm installing the BT2002 with HIPAA accelerator and BT adapter for SQL serv
er to generate 835 file on a server (TESTSERVER) where the SQL server is loc
ated on another box. So the interchangeDTA, BTM, SQ, XLANG, etc databases ar
e not in the TESTSERVER.  I have no problem generating 997 and 837 HIPAA fil
es. However, when it comes to generating 835 right after i start the SQL Ada
pter job, I got the error message below. I use the domain administrator acco
unt which also belongs to the local administrator group and can access the S
QL 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 passwo
rd.

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?

[ Post a follow-up to this message ]