Not able to connect with database to install AR Server?

August 24th, 2010 by Venkat

Read the possible causes carefully, it clearly says “Refer to Installation Document” before you attempt”.

One big mistake what everyone tends to do is start doing things when they have to read/research first. For any successful remedy installation, we need to tune the system and database first. All these details are readily available in BMC documentation, don’t get scared of by seeing the number of pdf pages, instead skim through the parts which you don’t need to know. Like, if your OS is Windows, you don’t have to read everything about LINUX/UNIX.

Regarding the error, it is based on database and connectivity to the database. Connectivity to the database is essential for remedy server as all the actions that are performed are ultimately end up in it. First thing you need to do here is, try connecting to database using a client software, based up on the database you are using, use the clients like Toad, WINSQL, SQL Management tool or any other preferred. If you are able to connect to the database, then go to the database setting to open the TCP/IP port.

Error “TCP/IP connection to the host XYZ using port number 1433 failed.” is caused with SQL database because the TCP/IP settings are disabled.

Follow these steps to fix this issue:

Set your SQL Server connections to allow TCP/IP:

  • Open the SQL Server Configuration Manager.
  • Click Network Configuration for your SQL Server instance.
  • Make sure that TCP/IP Protocol is enabled.
  • 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.)
  • Restart all SQL Server services to effect this change.

Just back a step on the remedy installer and click Next, it will detect the database instance, if not you can always manually.

If you still need help configuring TCP/IP ports, look here


Comments are closed.

%d bloggers like this: