When viewing a data source in the Information Centric Analytics (ICA) console under Admin > Integrations > Data Sources, the status displayed is:
This registered connection no longer exists.
The linked server for the data source in question has been removed in SQL. To determine which linked server is missing, run the following query (use the Server name from the Data Source list for the @Name variable):
DECLARE @Name varchar(255)
SET @Name=''
SELECT LinkedServerName
FROM LinkedServers
WHERE LinkedServerName LIKE '%'[email protected]+'%'
;
Connect to SQL Server using SQL Server Management Studio (SSMS). In SSMS, navigate to Databases > Server Objects > Linked Servers. The LinkedServerName value returned by the preceding query will be missing from this list.
Release : 6.5.x
Component : Integration Pack
Restore the missing SQL linked server by editing the integration's connection settings. Alternatively, you can manually create a linked server in SQL Server. To do this:
ICA Integration Guide:
https://techdocs.broadcom.com/us/en/symantec-security-software/information-security/information-centric-analytics/6-5-4/Integration_and_Solution_Accelerator_Guides_3/ICA_Integration_Guide_0/aboutIntegration.html