2

I installed Microsoft SQL Server 2016 Management Studio on my PC, and when I try to connect to a server, it shows this error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

I don't know what should be the server name. How can I connect to a server?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
  • 1
    You have only installed a client for SQL Server. The server name you will need to find out from whomever told you that you need SSMS to perform whatever tasks you've been asked to perform. – alroc Nov 14 '16 at 23:33
  • Management Studio is **just** the management program. It connects to Sql Server to let you manage tables, run queries, and other tasks. It does not actually host any database by itself. – Joel Coehoorn Nov 14 '16 at 23:44
  • Possible duplicate of [How to find server name of SQL Server Management Studio](http://stackoverflow.com/questions/16088151/how-to-find-server-name-of-sql-server-management-studio) – ahmed abdelqader Nov 15 '16 at 06:11
  • try type . (just dot) or local on server name text box , if your instance was default one (MSSQLSERVER) – ahmed abdelqader Nov 15 '16 at 06:12

2 Answers2

2

Run the command SQLCMD -L in a command prompt and you will see your available server names. If you need additional resources check out this answer: https://dba.stackexchange.com/questions/44171/find-all-version-of-sql-server-on-a-network

Community
  • 1
  • 1
BasicIsaac
  • 187
  • 8
0

enable protocals test TCP/ip Connectivity refer following link https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

Vishe
  • 3,383
  • 1
  • 24
  • 23