SSP v8.2.2.2012 and App Pool
Cannot open database "ServiceManager" requested by the login. The login failed.
Login failed for user '<AppPool ServiceID'.
I may be missing it, but I don't see anywhere in the documentation where it says the app pool ID should have access to the ServiceManager database. I have not given permissions in SQL for that ID to have any rights on the ServiceManager DB. The AppPool ID has DBOwner rights on the ServiceManagement and the CiresonAnalytics DB's but that's it. The AppPool ID is also in the Administrators role within Service Manager.
Is this error anything to be concerned about? Should I be giving the AppPool permissions on the ServiceManager database? The portal has been performing well for us since the upgrade, so I'm reluctant to change anything if I don't have to.
Thanks!
Answers