PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: Error Connecting
Topic Summary: SQL server suddenly not accessible by clients
Created On: 7/19/2016 7:20 PM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 7/19/2016 7:20 PM
User is offline View Users Profile Print this message


Posts: 14
Joined: 9/25/2013

Had no issues connecting previously, but now a lengthy error message is the only result when trying to connect.

"Sorry, an error occurred while opening a client connection: while setting up connection to central database: an error occurred while executing the SQL "Open": 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)"

Our IT dept cannot seem to fix this. The desktop that serves as the SQL server is operating seemingly normally. I was able to log into the SQL server application just fine from the local server desktop. What can the issue be?
 7/22/2016 4:22 AM
User is offline View Users Profile Print this message


Posts: 635
Joined: 2/25/2009

By default, SQL Server 2008 R2 Express Edition do not allow remote connections, so you need to change the setting to allow remote connection.

Also create an exception for SQL Server 2008 instance (i.e sqlservr.exe) and QL Server Browser service (sqlbrowser.exe) in Windows Firewall.

If you still run in to any problem, please visit to submit a ticket, to get assistance from our Tech Support Team


- PKI Support

FuseTalk Basic Edition v4.0 - © 1999-2019 FuseTalk Inc. All rights reserved.