Troubleshooting: Connection timeout issue on connecting to a SQL Server

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

Connection timeout issue on connecting to a SQL Server

SUMMARY
The error message is displayed each time you are trying to connect to the SQL Server.

SYMPTOMS

The following error message is displayed each time you are trying to connect to the SQL Server:
Error Message 4:
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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

RESOLUTION

Verify that SQL Server is available by connecting with the native SQL Server client (Enterprise Manager or SQL Server Management Studio).

Verify that SQL Server allows the remote client connections:

Verify that protocol that is used to connect to server is enabled on server:

Verify that TCP-port that is used to connect to the SQL server is correct for selected server instance(the default port number used to connect to unnamed SQL server instance is 1433 ). To connect to each out of the SQL server instances you can point the name of an instance(or machine name for unnamed instance) and TCP-port number it is listening on:
f.e. JAZZ,1433 or JAZZ\SQL2000,3333.

Verify that the SQL server instance is started.

Check the firewall settings to ensure that ApexSQL Diff connections are not blocked by the firewall.

LAST REVIEW
17 September 2007 Date of Last Review

Labels: ApexSQL Diff

posted by Irene Sanford on Tuesday, July 03, 2007

0 Comments: