TCP/IP connection to the host XXXX-XXX using port number XYZ failed.
Possible causes:
Database services are not available/?running or Network configuration is not configured correctly for TCP/?IP protocol or IP or host name/? port number is incorrect.
Follow the steps to avoid this issue:
Set your SQL connections to allow TCP/IP:
a) Open the SQL Server Configuration Manager.
b) Click Network Configuration for your SQL Server instance.
c) Make sure that TCP/IP Protocol is enabled.
d) View the TCP/IP Properties dialog box for your database instance, and make sure that the IP Addresses tab has a TCP Port number specified. (The default port is 1433.)
e) Restart all Microsoft SQL services to effect this change.
If possible do a system restart, which is not necessary under normal conditions, but if only the above trick fails, and retry the same.
This is should allow ARS Installer to find the SQL Database instance and continue ARS installation.
Detailed steps of ARS are postponed for another day 
Njoy
Venkat
Other posts:
Timeline(History) of BMC Action Request System Remedy
Remedy Template Library by pathworks_dan
BMC ARSystem Remedy Extensions and what they mean
Related posts:
- Not able to connect with database to install AR Server?
- Minimum DB2 database Transaction logsize for Installing BMC Remedy
- Remedy Issue: An Error Has Occurred in the Script on This Page
- Common Database Issues and Solutions with BMC Remedy AR Server
- BMC ARSystem Remedy Integration with MS Outlook
- Calculate database size requirements for new AR System Remedy
- Installation order of BMC AR System Remedy 7.1 and ITSM 7.0
