Thursday, September 07, 2006 7:23 PM
I have an application that is reading a message from a Service Broker Queue. When I use integrated security with an NT account it works fine. When I use a SQL Server User through Management Studio I can select from the Queue however, when I use this same account through the web app with the SQL Server User, I cannot see the Queue. Is there a grant that I must do to this account to get it to see the Service Broker Objects?
Monday, September 11, 2006 11:40 PMModeratorService broker doesn't use any special security/access checks other than the normal SQL Server security/ access restrictions. If the queue is visible from the SSMS, but not from the Web app, it means that the Web app it connects with different settings/credentials than the SSMS.
Tuesday, October 04, 2011 1:25 PM
What specific permissions do I grant so that an app can SELECT * from a queue?