2

I have newly installed following things on my system 

     - Microsoft SQL Server Management Studio 2014 
     - SQL Server 2017
     - Visual Studio 2015

When I tried to open SSMS for the first time, it asked me for the "Server Name" when I surfed I came to know that I have to check the instance name in Configuration manager-->Sql Services, but I couldn't find any services running in Configuration Manager, it is showing "There are no items to show"

Secondly, I also tried giving the permissions to my SQL Server services as mentioned in article here, but couldn't solve my issue.

Also I tried to check find the SQL Server instance name using the sqlcmd -L command, but it didn't show any servers, even though SQL Server is already installed.

What am I doing wrong?

enter image description here No Server Server Instance Found although Server is installed enter image description here enter image description here

LowlyDBA - John M
  • 11,059
  • 11
  • 45
  • 63
Maryam
  • 21
  • 1
  • 2

1 Answers1

1

SQLExpress is installed as a named instance. Try connecting to <server name>\SQLEXPRESS

Or localhost\SQLEXPRESS will work as well.

Aaron
  • 1,802
  • 1
  • 12
  • 23