Posts Tagged ‘tcp/ip’

Not able to connect with database to install AR Server?

August 24th, 2010

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

TCP/IP error while installing ARSystem Remedy on SQL Database?

March 26th, 2010

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
%d bloggers like this: