If it was on UX and Oracle, things would be much better. However, it is what it is.
Howard On Mon, Jun 21, 2010 at 2:22 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > Remember only a Windows instance of ARS can access an MS SQL Server > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of strauss > Sent: Monday, June 21, 2010 12:59 PM > 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. > > ** > 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/ > > -----Original Message----- > 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 > > -----Original Message----- > On Mon, Jun 21, 2010 at 3:08 AM, Joe D'Souza <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: > arsl...@arslist.org]on Behalf Of Howard Richter > Sent: Sunday, June 20, 2010 4:58 PM > To: 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 > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 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 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"