|
Home > Archive > BizTalk Server > October 2004 > BizTalk Adapter for SQL Server failed
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk Adapter for SQL Server failed
|
|
| Jan Eliasen 2004-10-11, 7:47 am |
| Hi
I posted this just around three weeks ago, but I haven't heard
anything. I have posted using my "Managed Newsgroups"-emailadress,
which should give me an answer within 2 business days, or what?
So, to Microsoft, here goes again:
I am using BizTalk Server 2002, and the adapter for SQL Server. Both
are installed in a Windows 2003 cluster in an active/passive mode.
Quite often, after my SQL Adapter jobs have been running just fine for
some time, they suddenly get suspended. I get a bunch of the
errormessage you can see in http://www.eliasen.dk/biztalk/rfsql.jpg
and after so many retries, the job gets suspended.
Now checking the username and password, as the eventlogentry suggests,
is hardly worth the bother, as the jobs run just fine for some time
until they suddenly get suspended.
Sometimes, I can resume the jobs, and they run fine, and other times,
I rightclick the Adapter-icon in the Adapter configuration snapin, and
select "Resume all jobs", and they all return to "Started", but they
are not running. Nothing gets read from the database, and the trace
utility shows no activity at all.
I have put a trace from the Adapter Trace Utility in
http://www.eliasen.dk/biztalk/output.zip - but it really doesn't say
much.
Hope someone can help me.
Jan Eliasen, MCP, MVP, MSDN, TechNet
--
Jan Eliasen, representing himself and not the company he works for.
| |
| Basil Cheng 2004-10-15, 9:11 pm |
| Hi Jan
You might want to check what account is used to run the Biztalk Server
interchange Application and the Biztalk Adapter for SQL server
application in Component Services, is not set to use the interactive user,
but with an account that is used to run the Biztalk Service..
If it is set to an interactive user, if no user is logged onto the box, it
might fail with that error when you run the SQL adapter.
Thanks.
Basil Cheng
Microsoft Biztalk Developer Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------[vbcol=seagreen]
| |
| Jan Eliasen 2004-10-15, 9:11 pm |
| Hi
You were right... the BizTalk Interchange comopnent was running as the
interactive user. That has probably solved the problem - thanks.
Jan Eliasen
On Mon, 11 Oct 2004 15:47:48 GMT, kokc@online.microsoft.com (Basil
Cheng (MS)) wrote:
[vbcol=seagreen]
>Hi Jan
>
>You might want to check what account is used to run the Biztalk Server
>interchange Application and the Biztalk Adapter for SQL server
>application in Component Services, is not set to use the interactive user,
>but with an account that is used to run the Biztalk Service..
>
>If it is set to an interactive user, if no user is logged onto the box, it
>might fail with that error when you run the SQL adapter.
>
>Thanks.
>
>Basil Cheng
>Microsoft Biztalk Developer Support
>
>This posting is provided "AS IS" with no warranties, and confers no
>rights.
>
>--------------------
--
Jan Eliasen, representing himself and not the company he works for.
|
|
|
|
|