question

Jackson1990-7147 avatar image
0 Votes"
Jackson1990-7147 asked Cathyji-msft edited

Issue to SQL server 2012

Hi,
There was no change to SQL server 2012 but why did the issue below arise?

TITLE: Connect to Server
------------------------------

Cannot connect to WIN-429I3QNHOQT\EXPR2012.

------------------------------
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-generalsql-server-integration-servicessql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Check if SQL server service is up and running from services.msc

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @Jackson1990-7147,

Please follow below steps to troubleshot the issue,

  1. Make sure SQL Server Service is running

  2. If a named instance, make sure SQL Server browser service is running. Make sure the instance name is spelled correct and there is actually such an instance on your target machine.

  3. If this is remote connection. Please make sure SQL Server is configured to allow remote connections and you have enabled TCP\IP protocol

  4. Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports

  5. Test server connectivity with PING from the client machine

  6. Test port connectivity using TELNET to the server and port (from step 4) from the client machine. For example
    TELNET <server-name> 1433

  7. Check firewall settings if step 5 or 6 connectivity test fails. Configure the firewall on the server instance of SQL Server to open ports for SQL Server and the SQL Server Browser port (UDP 1434).

If you have some confuse about the steps, please refer to Resolving could not open a connection to SQL Server errors to get more information.

If it is not work, please let us know .


If the response is helpful, please click "Accept Answer" and upvote it, thank you.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

That is a generic "could not connect to server" message and does not help diagnose the actual problem in any way.

I suggest you start here:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.