Howard, Try the port forwarding daemon - it should work if it is trying to contact the database on the default port..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Howard Richter Sent: Monday, June 21, 2010 12:29 PM To: [email protected] Subject: Re: (Maybe BUG) Issues installing ARS 7.5 on a remote MS SQL database, after the install the ARServer can't find the database. ** I think this is a bug in the installer. I just ended a very long webex with BMC support and here is what I think is going on. The 7.5 installer asks for the ip/port and instance name, however, when the installer builds the ar.cfg file it only uses the instance name. So the installer will build the database, however, when it tries to start up the arserver the database cannot be found (so the installer does not complete). Has anyone been able to install 7.5 on MSSQL that is not using the default port? Howard On Mon, Jun 21, 2010 at 3:08 AM, Joe D'Souza <[email protected]> wrote: ** Hello Howard, At the time the ARS is starting up, do you see any traffic hitting the database server, from the ARS Server? And if so, over what port? One way of finding out if the MS-SQL instance 2000 is being contacted over 1433 is looking up the logs of the 2000 instance. If you see activity there, coming from the ARS Server over port 1433, then you might want to consider port forwarding... Have you ever used a utility called portfwd for port forwarding? Maybe you could set that up on the database server and forward all traffic coming from the ARS Server through 1433 to 2564 just in case for some reason the ARS is sending it through 1433. I have used this utility on Linux and it is pretty straight forward to set up - at least on Linux the setup is pretty straight forward. The utility for Linux is a freeware available on sourceforge.net... I believe it works on Windows too, although I must admit I have never tried it on any other platform besides Linux.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Howard Richter Sent: Sunday, June 20, 2010 4:58 PM To: [email protected] Subject: Issues installing ARS 7.5 on a remote MS SQL database, after the install the arserver can't find the dataabase. ** All, For the past few days I have been fighting an install of ARSystem 7.5 patch 5 (and even tried patch 4) on to a remote MS SQL 2005 database. The remote server has both MSSQL 2000 and MSSQL 2005, so I am not using the default port of 1433 (since 2005 is set to use 2564 and it’s a named incidence. I have been able to get the installer to install and create the database and even the user, however, when the ARServer starts it cannot find the database. Also I cannot find any setting in either the ar.cfg or the ardb.cfg that is used for the port number of a database. I am working with BMC support, however, I thought that I would ask the list and see if anyone had some ideas. Thanks to all and happy father’s day, Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [email protected] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [email protected] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
