MS SQL Server Management Studio error for new query or attach DB

Wit Chepur 0 Reputation points
2023-01-21T15:03:57.6266667+00:00

Hellow! MS SQL Server Management Studio error for new query or attach DB:
error

SSMS version:
SQL Server Management Studio 15.0.18424.0

SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1

Microsoft Analysis Services Client Tools 15.0.19750.0

Microsoft Data Access Components (MDAC) 10.0.22621.1105

Microsoft MSXML 3.0 6.0

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.22621

Windows version:
Edition Windows 11 Pro

Version 22H2

Installed on ‎04.‎11.‎2022

OS build 22621.1105

Experience Windows Feature Experience Pack 1000.22638.1000.0

I think that Windows does not contain .Net Framework 4.7.2, which is required for SSMS to work, although .Net Framework version 4.8 is installed

How to run SSMS?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,311 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 115.5K Reputation points MVP
    2023-01-21T18:56:56.2+00:00

    So you get this error when you select New Query? Or is it only when you select Database-Attach?

    Since you are accessing SQL 2022, it could be that SSMS 18 is not fully geared up for SQL 2022. Then again, I don't have any issues with SSMS 18 + SQL 2022 myself.

    Unfortunately, it is not uncommon to see posts from people where SSMS is misbehaving grossly. SSMS is a fairly complex thing that builds on the Visual Studio Shell, so it is somewhat sensitive to disturbances in the environment.

    Two things to try:

    1. Download and install the preview of SSMS 19. If you are lucky, SSMS 19 will work for you, and it has more support for SQL 2022.
    2. Azure Data Studio (ADS). This is the most recent SQL tool from Microsoft that also runs on Linux and Mac. ADS is bundled with the SSMS download, so you have it already. Just look in the Start menu. Personally, I'm less fond of ADS, and it does not have the same amount of GUI support as SSMS, but it is improving. And if all you want to do is to run queries, you should be able to get by with it.

  2. jose de jesus 141 Reputation points
    2023-01-23T05:22:50.1766667+00:00

    It has something to do with your login

    here are some references:

    Error in SQL Server Management Studio when trying to attach a database: Cannot show requested dialog

    [https://kb.lenels2.com/home/error-in-sql-server-management-studio-when-trying-to-attach-a-database-cannot-show-requested-dialog

    Cannot show requested dialog" error message when you try to view properties of a database in a SQL Server 2012 instance

    [https://support.microsoft.com/en-us/topic/kb2714785-fix-cannot-show-requested-dialog-error-message-when-you-try-to-view-properties-of-a-database-in-a-sql-server-2012-instance-8237ffa4-1ac4-2299-49fb-1fc5d5c66d1f

    0 comments No comments

  3. jose de jesus 141 Reputation points
    2023-01-23T05:24:36.94+00:00

    It has something to do with your login

    please refere to these links:

    [https://kb.lenels2.com/home/error-in-sql-server-management-studio-when-trying-to-attach-a-database-cannot-show-requested-dialog

    [https://support.microsoft.com/en-us/topic/kb2714785-fix-cannot-show-requested-dialog-error-message-when-you-try-to-view-properties-of-a-database-in-a-sql-server-2012-instance-8237ffa4-1ac4-2299-49fb-1fc5d5c66d1f

    0 comments No comments

Your answer

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