Could Not Obtain Information About Windows Nt Group/User

Koenraad.DendievelKoenraad.Dendievel Posts: 5 Bronze 1
edited April 10, 2015 6:22AM in DLM Dashboard
After installing DLM dashboard (BETA) i got an error "Could Not Obtain Information About Windows Nt Group/User" on
*trying to modify a table. (logged in with windows domain account)
*trying to ad a db_role on master (logged in under sa-account)
*trying to change owner of database Redgate to sa instead of windows domain account
Msg 15404, Level 16, State 19, Procedure RG_SQLLighthouse_DDLTrigger, Line 5

What I did during installation before bug

I've changed the
DLM Dashboard Storage Service
DLM Dashboard Monitoring Service
DLM Dashboard Website Service
via services.msc to login as that same windows domain account.

I ran the installation script under the windows domain account.
If also set up email under same account.

What i did to fix it
0. Remove all databases/servers/environments through DLM website
1. Disable the RG_SQLLighthouse_DDLTrigger via Server Objects/Triggers
2. Recreate the trigger (script drop and recreate) and executed under sa

that seemed to fix it
so I think the problem was running the DLM install script with a windows domain account instead of a windows local server account or a sql account

If added 3 windows local server accounts
.DLMDashboardMonitor
.DLMDashboardWebsite
.DLMDashboardStorage

I’ve linked the 3 DLM services with these accounts. They all start.

I’ve added a server role
db_definition_viewer

GRANT VIEW SERVER STATE TO db_definition_viewer --SERVER ROLE
GRANT VIEW ANY DEFINITION TO db_definition_viewer --SERVER ROLE

I’ve added these accounts to the SQL Server
.DLMDashboardMonitor  server role db_definition_viewer
.DLMDashboardWebsite  server role db_definition_viewer (and public)

I’ve added a new database role to master
db_definition_viewer

And mapped them to db-logins
Master -> .DLMDashboardMonitor -> database role db_definition_viewer (and public)
Master -> .DLMDashboardWebsite -> database role db_definition_viewer (and public)
Redgate -> .DLMDashboardMonitor -> database role db_datareader (and public)
Redgate -> .DLMDashboardMonitor -> database role db_datareader (and public)

GRANT EXECUTE ON dbo.RG_SQLLighthouse_ReadEvents TO db_definition_viewer --MASTER ROLE
GRANT EXECUTE ON dbo.RG_SQLLighthouse_WriteError TO db_definition_viewer --MASTER ROLE
GRANT EXECUTE ON dbo.RG_SQLLighthouse_WriteEvent TO db_definition_viewer --MASTER ROLE
GRANT SELECT ON sys.sql_expression_dependencies TO db_definition_viewer --MASTER ROLE

I've mapped both logins to each database I wanted to add

Databasename -> sqllogin .DLMDashboardwebsite to dbuser .DLMDashboardwebsite (only public role)

Still get some errors "Can't connect to database" on the website though
Sign In or Register to comment.