August 11, 2009 at 1:52 am
Hi,
We have a clustered SQL Server database from which we need to add a message to a Microsoft Message Queue. I wrote a simple CLR app that gets called from a stored procedure that posts a message to a queue.
When we run this app in our development environment (non-clustered), the message gets added to the queue but when we promote it to the clustered environment, the message does not get added and we get the error "Message queue service is not available".
The Message queue isn't clustered, just the database. We installed the CLR app on a shared drive on the Cluster so that it would be available to all instances of SQL Server running on the cluster but still no luck.
Does anybody have any ideas as to what I need to do to get this to work? Does the CLR app somehow need to be "cluster aware" or anything?
Any help would be most appreciated.
Thanks.
July 12, 2010 at 6:02 pm
I have the same issue.
Was a solution ever found?
September 10, 2010 at 8:08 am
this may sound ignorant, but have you installed MS Messaging components? There are not installed generally in a default installation. You would get that error if this was the case.
The probability of survival is inversely proportional to the angle of arrival.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply