TCP Provider: No connection could be made because the target machine actively refused it. 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. Login timeout expired

Article:TECH87244  |  Created: 2009-01-06  |  Updated: 2012-02-16  |  Article URL http://www.symantec.com/docs/TECH87244
Article Type
Technical Solution

Product(s)

Environment

Issue



TCP Provider: No connection could be made because the target machine actively refused it. 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. Login timeout expired


Error



TCP Provider: No connection could be made because the target machine actively refused it.
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

Details :

The Above mentioned error appears while installing Backup Exec as Managed Media Server while trying to connect to the Central Administration Server.

 


 


Solution



1 Click on Start > Run > Type "CLICONFG"

2 Select "TCP/IP" and "Named Pipes" and click on "Enable"

 

3 Click on "Alias" tab

4 Check if Central Administration Server is added.

5 Click on ADD to add Central Administration Server

 

6 Select "TCP/IP" and Type the Server Alias and Server Name

7 Check the Option "Dynamically determine Port" and click OK

8 Click Apply & OK to exit the CLICONFG utility

Try reinstalling the Backup Exec with MMS Option. It should successfully communicate now with CASO Server.


Please Note : There are connection limitations for Microsoft SQL 2005 Express . For More information, please refer the Microsoft Document mentioned below

 http://msdn.microsoft.com/en-us/library/ms345154.aspx





 



Legacy ID



317157


Article URL http://www.symantec.com/docs/TECH87244


Terms of use for this information are found in Legal Notices