Chris, Thanks for checking.
Was it an upgrade or new install? I think the key is (from our testing) when the arserver starts up during the install process, the ar.cfg does not have the correct port info. Howard On Mon, Jun 21, 2010 at 1:58 PM, strauss <[email protected]> wrote: > ** > > 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: > [email protected]] *On Behalf Of *Howard Richter > *Sent:* Monday, June 21, 2010 11:29 AM > *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 > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _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"
