Solved

SQL connectivity errors

Posted on 2010-08-30
5
193 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 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 48

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

809 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