SSMS won't connect to SQL Server 2019

Question

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 everything3

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

what should I do?

question from:https://stackoverflow.com/questions/65890555/ssms-wont-connect-to-sql-server-2019

Answer 1

• 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.