March 7, 2002 at 4:22 am
I am trying out the sample 'Message Queue Task' on chapter 3
(Advanced tasks) of 'SQL Server 2000 DTS'.
I have setup MSMQ Dependent Clients on 2 WIN2K Servers(SP2) with
SQL 2000 installed on both the servers.
1)Server 1 - HBLWB629
2)Server 2 - HBLWEB539.
I have a DTS Package called MSMQ Send Task on HBLWEB539. This
task is suppose to send Global Variable as illustrated in the example
to server HBLWEB629 which contains a package called MSMQ Receive Task.
Server HBLWEB629 server has a PrivateQ called 'Private$\privq53901'
This Q is given full rights to be accessed by user Domain\tankho1
as well as Group 'Everyone'.
The 'MSMQ Send Task Package' on HBLWEB539 is owned and created by
Domain\tankho1 in SQL Server 2000. The Domain\tankho1 user is assigned
to the Administrator group on both the machines.
When I run the job on HBLWEB539 it fails with the below error
"Err: could not open MSMQ. Please make sure you have sufficent rights
to access them"
Can you help me on this, as I am not sure where I went wrong
Kindest rgds,
Chris.g
March 7, 2002 at 5:18 am
Sounds to me lik the permissions/access are not setup for SQL to be able to access the share itself. Remeber when you access a remote data source that SQL is not using your account like when you execute it manually nor does it use the owner. You have to have SQL Server service running under a domain account that also has rigths on the remote share to access. If your SQL is not running on a Domain account and you change you will need to stop and restart the service for the change to take effect (now this is a Microsoft statement in regards to remote backups). Note however I believe only SQL Server Agent has to be running under a domain account setup as Domain Admin for it work since it handles the job processes themselves, I also have my server setup that way and no issues from it running over 2 years now.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 7, 2002 at 10:14 pm
Hi Antares686,
I have the services checked on HBLWEB539,
then run under (MS-SQL Server and SQL Server Agent) Domain\tankho1 account. On HBLWEB629, the services are running under Domain\rajapg account.
Should the SQL Services on HBLWEB629 run under Domain\tankho1 to resolve the issue or
something else need to be setup.
Kindest rgds,
Chris.g
March 8, 2002 at 4:53 am
At this point not 100% sure, first is Domain\tankho1 you said it is an Adminstrator, is a member of Domain Admins or just a local adminstrator? If local make a member of the domain admins and test.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 03/08/2002 04:57:06 AM
March 8, 2002 at 11:17 pm
OK, to make things more clear, what I did is
to add Domain\tankho1 a member of the Admin
group in HBLWEB629 and HBLWEB539.
One more thing to let you know, On the 'MSMQ Send task on HBLWEB539, if I change the Q Destination to a Local Q on the same machine and execute the Message, Mgs is forwarded to the Private Q.
Still wondering why it can't communicate with an remote server Q. By the way I don't have any firewall.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply