Re: (Maybe BUG) Issues installing ARS 7.5 on a remote MS SQL database, after the install the ARServer can't find the database.
Joe, Thanks. My work around is to setup an aliases in the SQL configuration manager and then create a hosts entry to point to that aliases. Lets say the install tool has a bug, since it is asking and then using the port number for the first part of the install process and not the second part (which builds the ar.cfg). So when the arserver starts for the first time (during the install process) it cannot find the database that was created on the first part of the install. Sounds like a little testing needed to be done. Have a nice day, Howard On Tue, Jun 22, 2010 at 2:16 AM, Joe D'Souza wrote: > ** > 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: > arsl...@arslist.org]*on Behalf Of *Howard Richter > *Sent:* Monday, June 21, 2010 12:29 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. > > ** > 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 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 >> >> -- >> 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 >> >> _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 > > _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"
Re: (Maybe BUG) Issues installing ARS 7.5 on a remote MS SQL database, after the install the ARServer can't find the database.
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:arsl...@arslist.org]on Behalf Of Howard Richter Sent: Monday, June 21, 2010 12:29 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. ** 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 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 -- 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 _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"
Re: (Maybe BUG) Issues installing ARS 7.5 on a remote MS SQL database, after the install the ARServer can't find the database.
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 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 > > >
Re: (Maybe BUG) Issues installing ARS 7.5 on a remote MS SQL database, after the install the ARServer can't find the database.
This was an existing 7.5.00.004 install pointed at a default instance of SQL Server 2008 on a box that we took down to downgrade from Windows Server 2008 R2 to 2003 R2 after various problems with BMC RKM and other app software. I re-pointed the AR Server to a new, second instance on a custom port that I brought up on the pre-production Windows 2008 R2/SQL Server 2008 x64 box. I don't recall having that much of a problem moving it over, but we are using Kerberos connections so you first have to define an SPN in Active Directory for the specific named instance, and port, and domain user that you will be running the AR Server service with, so I had a little help from my AD architecture. The patch installation had no trouble on an existing system once I remembered to enter the custom port that matched the custom db instance. BTW, I have NEVER seen the db port recorded in an ar.cfg file, but I have been 100% Windows and SQL Server since 1997. 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 1:08 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. ** 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 mailto:stra...@unt.edu>> 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:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Howard Richter Sent: Monday, June 21, 2010 11:29 AM To: arslist@ARSLIST.ORG<mailto: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 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 th
Re: (Maybe BUG) Issues installing ARS 7.5 on a remote MS SQL database, after the install the ARServer can't find the database.
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 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"
Re: (Maybe BUG) Issues installing ARS 7.5 on a remote MS SQL database, after the install the ARServer can't find the database.
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 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: > 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 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 > > -- > 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 > > _attend WWRUG10 www
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/ 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 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"
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 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 > > -- > 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 > > _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"