Search code examples
sql-serversql-server-2012ssms

SSMS won't connect to SQL Server 2019


I have Microsoft SQL Server manager version 18.8 installed to my PC, as well as SQL Server 2019. Both are installed on my PC. I need to locally create and manage a database.

[1]

I am trying to connect the SSMS but it's not working. [2]

I entered to the services and restarted everything [3]

and I also enabled TCP/IP in configuration manager. [4]

what should I do?


Solution

    • You have a named instance of SQL Server named SQLEXPRESS (this is shown in parentheses within the SQL Server service name "SQL Server (SQLEXPRESS)" in the Windows Services MMC snap-in.
    • You need to specify the instance-name in the Server name: field.
    • You can only omit the instance-name for default instances.

    You need to specify .\SQLEXPRESS or (local)\SQLEXPRESS to be able to connect.