|
Home > Archive > BizTalk Server > May 2004 > Problems with clustered sql server
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 |
Problems with clustered sql server
|
|
| kinrowan@nospam.nospam 2004-05-01, 8:34 am |
| We recently clustered the SQL server installation that holds our BizTalk Server databases. Since then I have been unable to access BizTalk Messaging Manager 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 connection 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 that reads:
"The Response document is not a valid document.
This could be due to an incorrect BizTalk Server path, a failure in server authentication,.... If you want to change the izTalk Server Path, on the Tools 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 under 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 new, but may have pre-existe
d the change to the clustered SQL server - I don't access BTS on a daily basis so I may have missed another event that could have caused this.
Does anyone have any ideas?
kinrowan
| |
| kinrowan@nospam.nospam 2004-05-01, 9:34 am |
| No sooner should I post then problem resolved. It seems that in order to access the InterchangeBTM database (and probably others) from the Management applications 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 running 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 fine.
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 BTS databases - I was an admin on the original SQL server, so would have noticed any problems regarding
not having rights, but this seems counter-intuitive - I guess I expected that only the services account would need to have rights to the SQL server - and 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
| |
| Basil Cheng 2004-05-03, 11:38 am |
| 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.
|
|
|
|
|