Solved

SQL connectivity errors

Posted on 2010-08-30
5
190 Views
Last Modified: 2012-06-27
I can't connect to a SQL server using the name but can using localhost. The backups won't run and produce errors such as;
Message
[298] SQLServer Error: 10061, An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [SQLSTATE 08001]

We have allowed remote connections and all the TCP/IP and SQL Browser etc. are enabled. Doesn't make sense. Thanks
0
Comment
Question by:biotec
5 Comments
 
LVL 16

Expert Comment

by:carsRST
ID: 33560077
Couple of things you may check...

-Is port is set to 1433?  If not you may need to specify which port to use during connectivity.
-Are you using correct named instance when trying to connect?

0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 33560390
0
 

Author Comment

by:biotec
ID: 33675026
I've tried most everything and still have the same issue. I can connect from other workstations or servers but it seems it can't connect to itself. The services all start under the same account and can be restarted without problems. I can telnet to port 1433 with no problems. The only thing I notice is that the ip address that is used in the protocols property for tcp/ip shows three addresses. The correct one shows that the port is enabled but not active and the old ip address shows that it is not enabled but active and it also shows the 127 address as enabled and active. Otherwise, I actually right click on a backup job and it runs successfully but no backup ever exists for the job.
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 33699955
Wich edition of SQL Server 2005 are you using? And wich protocols are enabled (check in SQL Server Configuration Manager / Network Configuration)?
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2000: == Linked Server, With higher version == 16 103
SQL Syntax:  How to Find Commonality Among Similar Results 2 43
Passing value to a stored procedure 8 89
Query 14 54
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

948 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now