Unable to connect to SQL Express Error 26-Error Locating Server Instance Specified

0 votes

I am at a loss with one specific computer running SQL Server 2008 R2 Express.

  • TCP & UDP 1433, 1434 are both allowed inbound by Windows Firewall settings.
  • The Windows Firewall is set up to permit outgoing TCP & UDP on any port.
  • There are no active antivirus or firewall programs.

When I try to connect to xxx.xxx.xxx.xxx\sqlexpress, it times out with the following error:

TITLE: Connect to Server

Cannot connect to xxx.xxx.xxx.xxx\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)

I verified that the server permits remote connections. In the SQL Server Configuration, I have verified that TCP/IP is enabled and set to permit connections on the external IP 1433. Using Wireshark on my local machine, I was able to observe requests for 1433 UDP being sent to the distant server.

However, Wireshark on the distant server reveals no incoming 1433 UDP connection requests or anything coming from my external IP (with filtering to remote RDP from results). This leads me to believe there is a firewall problem. The PIX in front of our server is under the management of an outside firm that hosts the server. 

Aug 19 in Database by Kithuzzz
• 12,240 points
43 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers
0 votes
1 answer
0 votes
0 answers
0 votes
0 answers
0 votes
1 answer

Error: Cannot connect to the server using SA account - MSSQL Linux

The option is to reset the system ...READ MORE

answered Mar 17, 2019 in Database by Fatima
308 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 8,620 points
330 views
0 votes
1 answer

How do I UPDATE from a SELECT in SQL Server?

MERGE INTO YourTable T USING ...READ MORE

answered Feb 3 in Database by Vaani
• 7,020 points
121 views
0 votes
0 answers

How do I UPDATE from a SELECT in SQL Server?

INSERT INTO Table (col1, col2, col3) SELECT col1, ...READ MORE

Feb 4 in Database by Vaani
• 7,020 points
45 views
0 votes
1 answer

What is a stored procedure?

A stored procedure is a set of ...READ MORE

answered Feb 4 in Database by Neha
• 8,920 points
216 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP