Windows Server AppFabric–Reading the Monitoring Database from a Web Application
If you want to read the AppFabric Monitoring Database from a Web Application your web app will have to have permission to login.
If you try to run a web app that does not have permission you will likely see this
Cannot open database "AppFabricMonitoringDB" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.
You have two choices.
- Run the Web Application in an AppPool using an identity that has permission to login
- Grant permissions to the DefaultAppPool identity
Rather than directly granting logins via SQL, Windows Server AppFabric has security groups that you can use.
How To Enable DefaultAppPool to read the AppFabric Monitoring Database On Local Machine
Open a Command Prompt with Administrator privileges and run the command
NET LOCALGROUP AS_Observers "IIS APPPOOL\DefaultAppPool" /ADD
You may need to restart SQL Server or Reboot your machine for the change to take effect.
Comments
- Anonymous
April 27, 2011
Good Point Ron!!. I also been playing with the AppFabricMonitoring Db and I ran into the same issue. In case you want to check, I exposed the monitoring database as a data service, weblogs.asp.net/.../troubleshooting-your-wcf-web-apis-with-appfabric.aspx