Solved

SQL connectivity errors

Posted on 2010-08-30
5
194 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 143

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 49

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

730 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