Client Management Suite

 View Only
  • 1.  IT Analytics

    Posted Aug 26, 2014 03:48 PM

    I am new to IT Analytics and not familiar with SQL at all.  I have SQL off box in a cluster that didn't have Analysis services installed.  I was told by my DBA that Analysis services can only be installed during initial installation and would need to have its own instance. So now I have my CMDB on one server with Reporting installed, as well as Analysis & Reporting services installed on another server. Not sure if it matters if I need to use the Reporting server where the CMDB resides or if I can use the other box that has both installed together.

    I have installed CMS 7.5 HF 3 or 4 I can't remember off the top of my head, not sure if I'm ready to upgrade to SP1 yet. On the IT Analytics Symantec CMDB settings page is showing me a warning:

    "IT Analytics Client Server Management pack has been found to be in an incomplete state.  It is recommended that you click the Update Dependencies button below to attempt to restore the pack to a valid working state.  If the problem presists please check the log file for more details."

    When I did the update dependencies I get the following error in the log file:

    Exception updating CSMP dependencies

    System.Data.SqlClient.SqlException (.Net SqlClient Data Provider): Named Pipes Provider: Could not open a connection to SQL Server [2].

    OLE DB provider "SQLNCLI10" for linked server "ITANALYTICS_CMDB_SYMANTEC_CMDB_INFRA_SYMANTEC_CMDB" returned message "Login timeout expired".

    OLE DB provider "SQLNCLI10" for linked server "ITANALYTICS_CMDB_SYMANTEC_CMDB_INFRA_SYMANTEC_CMDB" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections.

    I was able to create the IT Analytics database on the Analysis server, but wasn't getting any cubes available to install.

    Any help in the right direction would be greatly appreciated.