Yes, our test 7.5 server is hitting a second instance of SQL Server 2008 Ent x64 on a completely different port. I just updated the AR Server to patch 005 today and had to give it the host SQL Server, the port, and the instance name. I actually forgot to give it the port and it defaulted to 1433, and came back with a detailed error dialog telling me that 1433 was for the default instance, not the one I had specified, and then I went back and gave it the custom port and it installed without error.
The only places that I have found the actual port recorded are in the registry, which won't help an AR Server not on Windows, and in the \BMC Software\ARSystem\ARSystemInstalledConfiguration.xml file... under BMC_DATABASE_PORT. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Howard Richter Sent: Monday, June 21, 2010 11:29 AM To: arslist@ARSLIST.ORG 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 <jdso...@shyle.net<mailto:jdso...@shyle.net>> 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:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>]On Behalf Of Howard Richter Sent: Sunday, June 20, 2010 4:58 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> 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 = hbr4...@gmail.com<mailto:hbr4...@gmail.com> LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _attend WWRUG10 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com<mailto:hbr4...@gmail.com> LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
