BizTalk Server - Msg Stuck in Work Queue after installing SQL Server SP 3a

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > June 2004 > Msg Stuck in Work Queue after installing SQL Server SP 3a





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 Msg Stuck in Work Queue after installing SQL Server SP 3a
Mike H

2004-06-26, 10:51 am

This happened on two servers.

Any ideas?

Thanks.
Mike
Everett Yang

2004-06-26, 10:51 am

SQL Server is remote to BizTalk, right? If so, make sure the MDAC versions
match on both machines. You can update MDAC on your BizTalk machine to at
least 2.7.

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn

Mike H

2004-06-26, 10:51 am

The problem was related to MSDTC. Because the new server was a ghost
of another server the SID was an issue. Uninstalling MSDTC and
reinstalling it solved the problem.

Mike

evyang@online.microsoft.com (Everett Yang) wrote in message news:<7c5mao5VEHA.2764@cpmsftngxa10.phx.gbl>...
> SQL Server is remote to BizTalk, right? If so, make sure the MDAC versions
> match on both machines. You can update MDAC on your BizTalk machine to at
> least 2.7.
>
> Sincerely,
>
>
> Everett Yang
> DSI - Microsoft BizTalk Server
>
> This posting is provided ?AS IS? with no warranties, and confers no rights.
> Subscribe at
> http://support.microsoft.com/defaul...msdn/nospam.asp
> &SD=msdn

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com