Solved

SQL connectivity errors

Posted on 2010-08-30
5
192 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 47

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

786 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