I installed 2017 LocalDB, then 18.6 MSSMS. But I couldn't connect to server.

David Fan 1 Reputation point
2020-08-19T15:39:57.067+00:00

TITLE: Connect to Server


Cannot connect to MY-PC\SQLEXPRESS.


ADDITIONAL INFORMATION:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476


BUTTONS:

OK


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,948 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Sreekanth Madambath 86 Reputation points
    2020-08-19T17:05:12.733+00:00

    Go to SQL server congratulations manager, start your sql services!

    0 comments No comments

  2. Cris Zhan-MSFT 6,631 Reputation points
    2020-08-20T04:05:28.177+00:00

    Hi,

    >MY-PC\SQLEXPRESS

    It looks like you are using the SSMS to connect to a local SQL Server named instance.

    Please use the SQL Server Configuration Manager to verify the instance is running and get the instance name, then make sure to enter the correct instance name(The name of the name instance is <computer name>\<instance name>).

    More details please refer to Troubleshoot connecting to the SQL Server Database Engine.

    ===============================================

    If the response helped, do "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.