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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
