We recently clustered the SQL server installation that holds our BizTalk Ser
ver databases.  Since then I have been unable to access BizTalk Messaging Ma
nager or BizTalk Server Administration.  When I try to expand the BTS Server
 icon in BTS Administration
, I get an error stating:

"Instances of MicrosoftBizTalkSever_Group cannot be enumerated: The connecti
on to the BizTalk Messaging Management database could not be opened."

When I try to access any objects in BTS Messaging Manager, I get an error th
at reads:

"The Response document is not a valid document.
This could be due to an incorrect BizTalk Server path, a failure in server a
uthentication,....  If you want to change the izTalk Server Path, on the Too
ls menu, click Options, and then specify a new BizTalk Server path."

I have run through the troubleshooting options at:
http://msdn.microsoft.com/library/d...erver_qksm.asp,
http://msdn.microsoft.com/library/d...ouble_aawe.asp, and
http://msdn.microsoft.com/library/d...ouble_upmg.asp;

My server has MDAC 2.7 installed, the default connection protocol is TCP/IP 
on port 1433,  and the BTS services account is a network administrator with 
dbo rights on the database.  When I terminal service into the BTS Server und
er my admin account (an acc
ount with admin rights to the machine and belonging to the BT Administrators
 group) I receive these errors, however, when I log in to the server as the 
services account I am able to connect without difficulty.  This problem is n
ew, but may have pre-existe
d the change to the clustered SQL server - I don't access BTS on a daily bas
is so I may have missed another event that could have caused this.

Does anyone have any ideas?

kinrowan

[ Post a follow-up to this message ]

No sooner should I post then problem resolved.  It seems that in order to ac
cess the InterchangeBTM database (and probably others) from the Management a
pplications you (the logged in user, not the BTS services account) must have
 rights to access the physi
cal server that's the active server in the sql cluster.  Since we are runnin
g our new cluster in fail-over mode, my admin account didn't have rights to 
that server.  Once I gave it rights I was able to access everything just fin
e.

My only question now is that I don't recall ever seeing anything indicating 
that the logged in user had to have rights on the SQL server to access the B
TS databases - I was an admin on the original SQL server, so would have noti
ced any problems regarding
not having rights, but this seems counter-intuitive - I guess I expected tha
t only the services account would need to have rights to the SQL server - an
d in fact my admin account has no right whatsoever to any of the databases, 
just to the server itself.

Did I miss something, or is this undocumented?

Thanks!
kinrowan

[ Post a follow-up to this message ]

Hi kinrowan

Please refer to the below article.

http://support.microsoft.com/?id=317990

Point 6 may be what is happening in your case.

Thanks.

Basil Cheng
Microsoft Biztalk Developer Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

[ Post a follow-up to this message ]