Error: 'HTTP Request failed' or 'Request timed out' when configuring one of the Solutions in Symantec Installation Manager

Products

• IT Management Suite
• Client Management Suite
• Server Management Suite

Issue/Introduction

When Symantec Installation Manager (SIM) is configuring one of the Solutions, the following error message appears:

"A critical error occurred: Product failed to install. See log for details. Configuration failed while attempting: Configure..."

As well you may see an entry mentioning:

HTTP Request failed:
 /Altiris/NS/Services/ProductConfigurationWebService.asmx

Request timed out.
   [System.Web.HttpException @ ]

This is what the actual error said in the NS logs:

Priority: 1
Process: AeXSvc (908)
Module: AeXSVC.exe
Source: Altiris.NS.Installation.ProductConfigurationWorker.ConfigureProduct
Description: Failed to configure C:\Program Files\Altiris\InventoryRuleManagementLP\Config\InventoryRuleManagementLP.config

( Exception Details: Altiris.NS.Exceptions.DatabaseNotReadyException: Failed to construct DatabaseContext object. Connection to database failed. ---> Altiris.NS.Exceptions.AeXException: Failed to open database connection. Current user is <Domain>\<Username>. Error: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Environment

ITMS 8.x

Cause

In this case the issue is not with Symantec Installation Manager (SIM). The problem comes from the connections to the SQL Server.

This is the message that we got when trying to access the SQL Server:

TITLE: Connect to Server
------------------------------

Cannot connect to <SQLServerName>.

------------------------------
ADDITIONAL INFORMATION:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=1326&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Resolution

1. Disable Windows firewall, or make an exception and add port number for SQL, this works well if you have only one instance of SQL Server, if you have more than one SQL Server instance then you should have to enable all other ports used by SQL Server.
2. If you are using SQL Server 2005 or later, then use SQL Server Surface Area Configuration.
3. On the SQL Server, Go to Start > Microsoft SQL Server > Configuration Tools > SQL Server Surface Area Configuration.
4. Click on Surface Area Configuration for Services and Connections. A new window should open.
5. Under Database Engine > Remote Connections, choose 'Using both TCP/IP and named pipes'.
6. Restart SQL Server service to take effect.

Also you can check SQL Server Configuration Manager

Start> Sql Server Configuration Manager> SQL Server Network Configuration> Protocols >> Make sure all options are enable

Note:
If necessary, confirm the connectivity between the SMP and SQL Database ODBC connection.

1.     On the SMP Server:
   • Create a new text file and rename it as “TestConnection.udl”
   • Right-click on the “test.udl” and go to the "Properties" tab
   • In the connection tab, do the following:
     • a.Under “Provider” select the “Microsoft OLE DB Provider for SQL Server” and click on “Next”.
     • b.Verify in the “Security” tab, user has full permission.
     • c.On the “Connection” tab, Under the “Select or enter a server name”  select the “servername\instancename”
     • d.Select “Use Windows NT Integrated security” under “Enter information to log on to the server”
     • e.Select the database under “Select the database on the server:”
   • If the test connection completes successfully, the connection should be re-established with the SQL server.