Can not login on the SP Portal after performing a SP Portal database migration

Products

• CA Automic Sysload

Issue/Introduction

Affects Release version(s): 5

Error Message :
On sldphp.log:
#####################
[25-Sep-2012 08:23:28] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'odbc_mssql error: [08001: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.] in EXECUTE("SELECT sld_primarylanguage_shortlabel FROM sld_primarylanguage WHERE sld_primarylanguage_id=2")
######################

On sldphpcli.log:
######################
[25-Sep-2012 08:03:13] sldf_batch.php [22] Exception: odbc_mssql error: [08001: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.] in EXECUTE("SELECT DISTINCT sld_report_templates.sld_template_id, ...
######################

Patch level detected:Sysload Portal 4.00
Product Version: Sysload 5.7.0

Description :Can not login on the SP Portal after performing a SP Portal database migration

Environment

OS: Windows Server 2008
OS Version: 2008 R2

Cause

Cause type:
Configuration
Root Cause: A firewall on the MS SQL Server blocks the connection from the remote server where SP Portal has been installed.
By default, Microsoft Windows enables the Windows Firewall, which closes port 1433 to prevent Internet computers from connecting to a default instance of SQL Server on your computer. Connections to the default instance using TCP/IP are not possible unless you reopen port 1433. The basic steps to configure the Windows firewall are provided in the following procedures. For more information, see the Windows documentation.

Resolution

Add an exception on the firewall for the Sqlservr.exe or modify the database instance to listen on a specified port.
See the possible solutions on the Microsoft site:
http://msdn.microsoft.com/en-us/library/ms175043.aspx

Fix Status: No Fix
 

Additional Information

Workaround :
N/A