Cannot open SQL server Management Studio in Windows 11

DUK 20 Reputation points
2023-01-12T10:19:57.6+00:00

Hi All,

I have installed MS SQL 2008 Express R2 in the Windows 11 Laptop. Installation has successfully completed. But when I try to open SQL server management studio, it is not opening. Can anyone give solution to sort out this issue.

Please note that I can open SQL Server Business Intelligence Development Studio, SQL Server Configuration Manager and Reporting Services Configuration Manager without any issue.

Kindly tell me how to open MS SQL 2008 Express R2 - Management Studio in windows 11 machine.

Thank You

Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
{count} votes

Accepted answer
  1. Olaf Helper 47,436 Reputation points
    2023-01-12T10:32:00.7266667+00:00

    MS SQL 2008 Express R2 - Management Studio

    SQL Server 2008 R2 and SSMS of the version are out-of-support since a very long time, and especially not on Win 11.

    Use the latest SSMS version from

    [https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16


2 additional answers

Sort by: Most helpful
  1. LiHongMSFT-4306 31,566 Reputation points
    2023-01-13T06:42:16.81+00:00

    Hi @DUK

    As experts answered above, try install the latest version SSMS 18.12.1.

    You could also try the Repair when you uninstall SQL Server Management Studio.

    • Repair – Select this option to repair SQL Server Management Studio install on the computer.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. DUK 20 Reputation points
    2023-01-17T06:37:53.8933333+00:00

    Hi All,

    I de-installed existing management studio and installed 18.12 version. Now it is working.

    [https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

    Thank you for all

    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.