0

Installed SSMS 2017 version. When I launch it first time, it asks for server name to connect to. I installed SQL server 2014 already. But I don't know the name of the server. I tried giving server name as "local". But it wouldn't accept. It says "Cannot connect to to local" Error: 53

Since I installed SQL server on my local machine, "local" should be acceptable name as a server to connect to from SSMS.

server name?

SQLServerNewBie2
  • 35
  • 7
  • Try `(local)` use the parenthesis around the word local. – SS_DBA Feb 14 '18 at 21:02
  • Possible duplicate of [How to connect to local instance of SQL Server 2008 Express](https://stackoverflow.com/questions/360141/how-to-connect-to-local-instance-of-sql-server-2008-express) – Tab Alleman Feb 14 '18 at 21:46

5 Answers5

2

.

localhost

127.0.0.1

Any of these will connect to sql server running on your local machine.

If you installed sql as a named instance, then .\myinstance, localhost\myinstance, etc

StrayCatDBA
  • 2,740
  • 18
  • 25
2

You can use (.), or local or localhost.

If you used named instance, follow the next:-

Use Browse for more, for getting the accurate server name as next screen shots;-

enter image description here

and under Database Engine, you will get the accurate server name

enter image description here

ahmed abdelqader
  • 3,409
  • 17
  • 36
  • when I click on "Server Name" and select "Browse", nothing shows up. And I don't see SQL Server Browser service at all on my machine. – SQLServerNewBie2 Feb 14 '18 at 22:21
  • it seems you installed SSMS, without installing SQL Serer Engine, Install SQL Server Engine 2017 from here: https://www.microsoft.com/en-us/sql-server/sql-server-downloads – ahmed abdelqader Feb 14 '18 at 22:27
0

If you have Db connection you can use this command

select @@servername + '\' + @@servicename

you can also check SQL Server Configuration Manager.

In Configuration Manager you need to find SQL Server Service. When you Double click the SQL Service and navigate through Service Tab, you need to see SQL Server Name

Derviş Kayımbaşıoğlu
  • 28,492
  • 4
  • 50
  • 72
  • when I clicked on "SQL server configuration manager", it says "CAn't connect to WMI provider. You do not have permission or the server is unreachable" – SQLServerNewBie2 Feb 14 '18 at 22:24
0

It should be localhost, just setup my SQL server last month and had to find this information aswell.

JavanPoirier
  • 442
  • 3
  • 9
0

You need connect using . only.

enter image description here

connect Local instance using .

enter image description here

enter image description here

Vishe
  • 3,383
  • 1
  • 24
  • 23