Our DBA team doesn't see the value in monitoring the model database on all of our SQL installations, consequently, the service account used does not have rights on the model database. This affects the entire instance status which turns it grey. How can I stop AppInsight from trying to collect data about a specific database?
This is the SQL script that we are using to give the service account access to database.
----------------
CREATE LOGIN [WJDOM\svc_orionmon] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
go
USE [master]
GO
CREATE USER [wjdom\svc_orionmon] FOR LOGIN [wjdom\svc_orionmon]
go
grant execute on xp_readerrorlog to [wjdom\svc_orionmon]
grant view server state to [wjdom\svc_orionmon]
grant view any definition to [wjdom\svc_orionmon]
GO USE [msdb]
GO
CREATE USER [wjdom\svc_orionmon] FOR LOGIN [wjdom\svc_orionmon]
go
EXEC sp_addrolemember N'db_datareader', N'wjdom\svc_orionmon'
GO
----------------
