CODEWITHSUNDEEP
sql-serversql-server-2012ssms
NourMawla
NourMawla

Reputation: 17

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?

Upvotes: 1

Views: 7016

Answers (2)

Christian
Christian

Reputation: 1260

Try connecting using .\SQLEXPRESS as the server name.

It seems you have created an instance with the name SQLEXPRESS. With SQL server you can create "instances". Each instance is like its own separate database engine and has its own list of databases, users and so forth. There can be one default instance which would be just the computer name or .. In your case you have a named instance "SQLEXPRESS" which you need to address using .\SQLEXPRESS or <computername>\SQLEXPRESS.

Upvotes: 0

Dai
Dai

Reputation: 155648

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

Upvotes: 1

Related Questions