How to find server name after installing SSMS 20.2?

Rade Rade 20 Reputation points
2025-02-16T12:29:22.3966667+00:00

I have installed SSMS 20.2 to my home computer but don't know what Server name to add. I saw on other forums to type a single dot, but it does not work. I chose Browse for more, but could not find anything under Local Servers.

Thank you very much for your help

SQL Server Other
{count} votes

Accepted answer
  1. ZoeHui-MSFT 41,491 Reputation points
    2025-02-17T01:34:03.75+00:00

    Hi @Rade Rade,

    Please make sure that you have installed SQL Server as well.

    SSMS just provides tools to configure, monitor, and administer instances of SQL Server and databases.

    You may check Services via Command Prompt:

    sc query | find /i "SQL Server"
    
    

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2025-02-17T07:00:37.38+00:00

    I have installed SSMS 20.2

    SSMS = "SQL Server Management Studio" is just a tool, not the database engine.

    You have to install SQL Server as well, e.g. the free Express Edition, see

    https://www.microsoft.com/en-us/sql-server/sql-server-downloads

    1 person found this answer helpful.

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.