dbTalk Databases Forums  

Can not open MSMQ. Please make sure you have sufficient rights to

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Can not open MSMQ. Please make sure you have sufficient rights to in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Navnit Mehta
 
Posts: n/a

Default Can not open MSMQ. Please make sure you have sufficient rights to - 12-21-2005 , 04:46 AM






Hi,

I am trying to send a MSMQ message from a DTS package using Message Queuing
Task. I am getting the following message when I am try to send the message to
a Private Queue on a remote machine "Can not open MSMQ. Please make sure you
have sufficient rights to access them." But I am successfully able to insert
the message in a Queue which is defined on the local machine. Both the
machines are on the same domain.
The SQL service account has permissions on the Queue (In fact I have given
everyone full control permissions on the queue).

I have Win2k3 Server SP1, SQL 2000 SP3 environment.

Is there any special setting we have to do for this thing to work ?

Thanks in advance.
--
Once you open a can of worms, the only way to recan them is to use a larger
can

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.