port needed for sqldependency?

Question

I have on my local dev enviroment set up a Sqldependency which works fine, I get notified when changes occur. But whe I try to monitor the live database the changes in the database is not seen in the "private void dependency_OnChange(object sender, SqlNotificationEventArgs e) ", is there some ports that need to be opened on the server?

Answer 1

Make sure the Service Broker is enabled on your production database.

In SSMS, you can find this under Database Properties, Options or you can run

SELECT name, is_broker_enabled FROM sys.databases;

The is_broker_enabled bit should be set to 1.

Answer 2

I found the solution here http://blogs.msmvps.com/siva/2011/11/22/subtle-sqldependency-notification-issue/ On the production server I had to enable ARITHABORT on the database. After enabling that it worked perfect.