Ouch! On Fri, Apr 9, 2010 at 8:16 AM, Rick Cook <remedyr...@gmail.com> wrote:
> ** > I guess I don't understand what makes it so difficult for BMC to fit their > own products together in a reasonable amount of time, or to manage releases > so that only ONE iteration of a patch is released. > > If only BMC sold products to manage releases and impact, maybe they could > use such products, and the ITIL processes behind them, to help them manage > internal issues. If only... > > Rick > ------------------------------ > *From: * strauss <stra...@unt.edu> > *Date: *Fri, 9 Apr 2010 09:32:28 -0500 > *To: *<arslist@ARSLIST.ORG> > *Subject: *Re: Re : analytics7.6/ DB MS SQL 2005 > > Since I had opened an issue on both Analytics 7.6 and Dashboards 7.6, I > did eventually get an answer of sorts. On Dashboards, the DIL engine is > apparently from a third party, and is only now being adjusted to talk to SQL > Server 2008. They expect to release an update to 7.6 this summer that > supports SQL 2008. By the time I need to deploy it into production, it > might actually work; I just can’t test it or get familiar with it in the > interim. > > > > Back to Analytics, if you are installing 7.6 it now attempts to support > Windows authentication to SQL Server – but not really. The installer will > work in Windows auth mode IF you are logged in to the server with the > account that has sysadmin access to the ARSystem db on the remote SQL > Server, but ONLY IF you also have named pipes open to the network on the SQL > Server (which is NOT by default – I believe that it is more of a security > risk than TCP/IP). This isn’t documented… it’s just what I found would > eventually work after studying the installer logs and error logs from the > failures. The trouble is, it ONLY works for the Analytics installer. When > you go to edit the connection to the ITSM Universe in the BOXI Designer > later, Analytics still ONLY knows how to connect using SQL Server > authentication, making any attempt to install using Windows authentication a > complete waste of time. Between that and the unexpected requirement for > named pipes access over the wire to your ARSystem db - just to install, I > can recommend that you ignore Windows authentication to SQL Server > completely and plan from the beginning to use SQL Server authentication for > Analytics. It’s also the ONLY way that you will ever get Dashboards to > connect (we tested it last spring successfully – version 2.5 against our ARS > 7.1 servers on SQL Server 2005. > > > > So, even though the AR Server (7.5.x) is perfectly happy installing on and > using SQL Server 2008 in Windows-authentication-only mode (IMHO the most > secure method, using AD domain service accounts), very few of the BMC > auxiliary products are capable of connecting to the ARSystem db in that > configuration. > > > > 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 *Rick Cook > *Sent:* Friday, April 09, 2010 9:04 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Re : analytics7.6/ DB MS SQL 2005 > > > > ** > > ... <crickets chirping> ... > > I don't think that was a rhetorical question, in case anyone official is > wondering... > > Rick > ------------------------------ > > *From: *strauss <stra...@unt.edu> > > *Date: *Wed, 7 Apr 2010 14:06:20 -0500 > > *To: *<arslist@ARSLIST.ORG> > > *Subject: *Re: Re : analytics7.6/ DB MS SQL 2005 > > > > On SQL Server 2008, Analytics 7.6 created one table within arschema, and > four external to it in the ARSystem database: > > > > ANA:Fiscal_Calendar (and 7 associated Active Links) > > > > ANA_REPORT_TRANSLATION > > ANA_REPORT_LOCALE > > DENORMALIZE_BSM_RELATIONSHIPS > > ANA_TIMEZONE_INFO > > > > BTW, Analytics 7.6 is able to connect to an ARS 7.5 patch 4 database hosted > on SQL Server 2008 – it makes an OLE DB connection using a MS SQL Server > 2005 driver. > > > > In contrast, BMC Dashboards 7.6 is completely incapable of connecting to > the ARSystem db if it happens to be hosted on SQL Server 2008. I wasted two > days before finding that out. So even though it supports ITSM 7.6, and by > inference ARS 7.5.00.003 or higher, it does NOT support the database > version(s) that ARS does (and has for over a year now). SQL Server 2008 was > released in August 2008, and ARS 7.5 in January 2009. What has the > Dashboards team been doing for the last 15 months??!! > > > > 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 *Frex Popo > *Sent:* Friday, March 05, 2010 7:47 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re : analytics7.6/ DB MS SQL 2005 > > > > ** > > > > Better still... > > > > select name, type from sysobjects > > order by 2, 1 > > > > Thanks > ------------------------------ > > *De :* Frex Popo <frexp...@yahoo.fr> > *À :* arslist@ARSLIST.ORG > *Envoyé le :* Ven 5 Mars 2010, 14 h 44 min 54 s > *Objet :* analytics7.6/ DB MS SQL 2005 > > Anyone with a working instalation of Analytics 7.6 can tell me what objects > get created by the installed? > > > > Can anyone run this select on their databse and send us a listing? > > > > -- select name, type from sysobjects order by name > > > > Very much appreciated > > frex > > > > > > > > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _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"
