For anyone who's attempting to install the example:
My attempts failed the first two times. The first time upon starting the instance. I got a 'RPC not found' error. After deleting the instance, I couldn't reinstall it until I found 'Unregister...' when right clicking the Notification Service node in SQL Server Managment Studio. And the instance was still listed there. I then could reinstall the instance, but not enable it. At first I didn't give me a clear error message besides: "Operation completed successfully!" :-), which it didn't. After trying a few times the message changed to: can't read database table .... stored procedure ... .
After first doing step 4 (which sets some login security settings) and then try to enable again (I installed the instance without checking the enable checkbox), I succeeded.
And I was able to start the Notifaction Service without the RPC error.
So the message: keep trying you it will work.
PS: The NotificationServicesHost can't be an IP address it must be the name of the server (the computername).
7:07:38 PM
|