March 31, 2015 at 2:01 pm
below is the scenario
I have implemented a solution to bring sql backup history from all servers using stored proc (SQL cmd to connect to remote servers and used bulk insert to load data in centralized database). I have used service broker when I call initiator its working, but receiver is failing with error
The activated proc running on queue output the following: ' You do not have permission to use the bulk load statement.'
the account used is same as the account running SQL server agent and database services. Same account is sysadmin on all servers. when I execute using same account manually it works perfect. when I call with SB it fail with above error. I try to capture using SQL profiler it is using same account but still failing even though it is sysadmin across all the servers.
Any clue?
April 4, 2015 at 10:52 am
Quick question, have you granted the appropriate permissions to the Service Broker, see GRANT Service Broker Permissions (Transact-SQL) ?
😎
April 7, 2015 at 7:18 am
account is sysadmin across all servers. Do you think still we need to grant permission explicitly ?
September 4, 2015 at 6:43 am
did you ever find an answer to this problem?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply