Share via

Is there a 64 bit SSMS?

子明 李 21 Reputation points
2021-09-29T11:48:06.173+00:00

I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,166 questions
0 comments
Accepted answer
  1. Erland Sommarskog 104.8K Reputation points MVP
    2021-09-29T21:58:51.447+00:00

    No, there is a not a 64-bit SSMS, because as Olaf says the underlying shell is 32-bit, because the Visual Studio folks has for many years refused to make VS 64-bit. But, about 20 years later than everyone else, the next version of Visual Studio will be available in 64-bit! So maybe there will also be a 64-bit SSMS in the future.

    2 people found this answer helpful.

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,746 Reputation points
    2021-09-29T12:16:40.763+00:00

    No, there is no 64 bit SSMS available.
    SSMS is a plugin for Visual Studio and VS comes only as 32 bit app.
    Same for SSDT = SQL Server Data Tools.

    2 people found this answer helpful.
    0 comments
  2. Kosovari_ 81 Reputation points
    2021-09-30T01:58:15.67+00:00

    32 bit SSMS INTEGRATION POWER OF FEAUTURES OPTIMIZER QUERIES AZURE EXTRA TOO APPLIED BY MICROSOFT LATEST UPDATES . . GREETINGS FROM KOSOVO DEAREST BRO YOUNG "KOSOVAR" CITIZEN .

    0 comments
  3. AmeliaGu-MSFT 13,966 Reputation points Microsoft Vendor
    2021-09-30T02:37:35.49+00:00

    Hi 20274843,
    Agree with Olaf and Erland.
    Quoted from the docs:

    SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. Azure Data Studio is a cross-platform tool that runs on macOS, Linux, as well as Windows.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.