Hi All - I am new to SEPM. I am trying to setup IT analytics for SEPM and leverage the cubes/reports. I have installed ITAnalytics 2.1 and I am unable to add a datasource connection to embedded database. I have SEPM installed on "Server1" and IT Analytics is installed on "Server2". I have setup SSRS and SQL server 2012 on "Server1". I have setup the ODBC connection to my sem5 (embedded DB) successfuly but not able to add connection via IT Analytics. I am getting the below error message.
Can someone please help me acomplish this task. Thank you so much in advance.
A connection to Symantec Endpoint Protection database failed.
Exception: TCP Provider: The requested name is valid, but no data of the requested type was found. OLE DB provider "SQLNCLI11" for linked server "ITANALYTICS_SEP_ITANALYTICS_SEPM_SEP1SRV_SEM5" returned message "Login timeout expired". OLE DB provider "SQLNCLI11" for linked server "ITANALYTICS_SEP_ITANALYTICS_SEPM_SEP1SRV_SEM5" 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. For more information see SQL Server Books Online.".