News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Can't open pages "Data...

Small and medium business | Business Central, N...

Answered

Can't open pages "Database Locks", "Database Missing Indexes" and "Database Wait Statistics"

(1) Share

Report

Report

Posted on by Community member

13

We are running BC22 on prem, and we have issues opening thae pages Database Locks, Database Missing Indexes and Database Wait Statistics.

I am guessing it is because the BC system/service user does not have the appropriate rights on the SQL server. Does anyone know where I can find the documentation on which SQL rights are needed in order to open these pages - or any other hints?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (1)

Community member 13 on at

Like (1)

Report

Can't open pages "Database Locks", "Database Missing Indexes" and "Database Wait Statistics"

We were missing the VIEW SERVER STATE permission.
Verified answer

gdrenteria 13,057 Most Valuable Professional on at

Like (0)

Report

Can't open pages "Database Locks", "Database Missing Indexes" and "Database Wait Statistics"

Hi

You can check the event viewer and see what more information it gives you when you open these pages.

best regards

Gerardo

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans