search

dyatchenko / ServiceBrokerListener

Component which receives SQL Server table changes into your .net code.
MIT License
256 stars 94 forks source link

Permission not sufficient when broker or trustworthy not set #62

Open mniess opened 5 years ago

mniess commented 5 years ago

If the ServiceBroker is not enabled or the database is not trustworthy, the permissions stated in code are not sufficient.

The SQL_FORMAT_INSTALL_SEVICE_BROKER_NOTIFICATION does not run successfully, because it trys to fisx these database settings. For this to execute the ALTER DATABASE permission is needed.

I suggest to remove the part that automatically trys to fix the database settings instead of instructing to grant ALTER DATABASE permission. It is not needed during normal execution.

Is there a reason other than convenience to have the settings adjusted automatically?

predatorfromekb commented 4 years ago

@mniess the same problem(

if this field would not be a constant, i could change it value by reflection

predatorfromekb commented 4 years ago

@dyatchenko can i create pull request?