Hi Chris, Thanks for all of the details! I am still unclear if Analytics and/or Dashboards will work with a SQL 2008 server if SQL Authentication is allowed. Is the problem with connecting to SQL 2008 altogether or if you only allow Windows auth?
I agree that Windows auth only is the most secure. Unfortunately too many apps still have issues with it (IMHO) so we stick with allowing SQL auth. We just bought licenses for Analytics/Dashboards, I am going to be very unhappy (and my leadership as well) if we can't use it. Thanks, Jason On Fri, Apr 9, 2010 at 7:32 AM, strauss <stra...@unt.edu> wrote: > ** > > 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"
