?
Solved

provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Posted on 2009-02-20
1
Medium Priority
?
2,950 Views
Last Modified: 2012-05-06
Hello Experts,
I cannot connect a remote database server.When I try to login I get the following error:
provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I also attahed the screenshot of Database Configuration Manager tool settings. I have tried Surface Area Tools etc. but could not solve the problem.
Please help
ERROR.JPG
0
Comment
Question by:innocent1973
1 Comment
 
LVL 41

Accepted Solution

by:
ralmada earned 2000 total points
ID: 23693431
Are you sure that your SQL Server instance is accepting remote connection?
Check if the local/remote connections have been enabled for ur instamce....Launch SQL Server Surface Area configuration...Connections and services...Check Local and Network connections.....
 Also, make sure SQL Browser on the remote server is be enabled and UDP port 1434 should be put into exception if firewall presents.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question