SQL Server 2022 MDS not showing data on portal after update

Stawik 0 Reputation points
2026-08-28T09:36:30.6566667+00:00

Hi

After installing an updates on SQL Server 2022 i have problem with MDS. When i go to website and open a model I do not see data in it. Data are avaiable in views and by Excel addin. Is this some bug or I could have broke sth?

Daniel

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deepesh Dhake 1,165 Reputation points
    2026-08-28T12:58:35.6933333+00:00

    Your symptoms point to the MDS database schema not being upgraded after the patch - the most common cause.

    You can try this in order:

    Run the database upgrade. MDS Configuration Manager then Database Configuration then select your DB. If it prompts to upgrade, back up first, then run the Upgrade Database wizard.

    If the wizard errors, check for an orphaned/alias user account - drop it, sp_changedbowner 'sa' if needed, re-run.

    Recycle the MDS app pool and restart IIS.

    Clear browser cache or try another browser.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.