Article Number
000001780
Applies To
RSA Product Set: ECAT, NetWitness Endpoint
RSA Version/Condition: 4.0.0.5, 4.0.0.6, 4.2.x, 4.3.x, 4.4.x
Platform: Windows
O/S Version: 2008 Server R2, 2012 Server
Issue
Unhandled exceptions are being thrown when attempting to access the Modules Summary tab if they do so using the ECAT User L1 Analyst or L2 Analyst user permissions.
Cause
After upgrading from ECAT 4.0.0.5 or 4.0.0.6 to any higher version, an unhandled exception is thrown if an L2 Analyst or L1 Analyst user clicks on an item in the Modules Summary tab.
This is because for ECAT 4.0.0.5 and 4.0.0.6, the Linked Servers were created as “@srvproduct = N'MSSQL', @provider = N'SQLNCLI',” which have been changed post 4.0.0.6 to “@srvproduct=N'MSSQL_NATIVE_CLIENT', @provider=N'SQLNCLI'.”
Resolution
After upgrading from ECAT 4.0.0.5 or 4.0.0.6, do the following:
- On the ECAT Primary Server, extract the existing LinkedServer connection as follows:
In SSMS, connect to your server instance > Server Objects > LinkedServers > XXX (Linked Server of the Primary Server as well as Linked Server of any Secondary Servers) > right-click and select Script Linked Server As > Create To > New Query Window > Save this file. - On the ECAT Primary Server, drop the linked servers for Secondary if the srvproduct is “MSSQL” (this can be checked in the script generated in step 1). Do this for both the linked servers if using multi-server configuration.
- Execute the following script on the ECAT Primary Server, by providing the details of the Secondary Server:
DECLARE @RCINTDECLARE @ServerNameNVARCHAR(100)DECLARE @AliasNVARCHAR(50)DECLARE @ECATDBNameVARCHAR(50)DECLARE @ActiveBITDECLARE @RemoteUserNVARCHAR(50)DECLARE @RemoteUserPasswordNVARCHAR(50)DECLARE @PortINTDECLARE @FK_LinkedServersINTDECLARE @ErrorMessageNVARCHAR(2048) -- TODO: Set parameter values here. EXECUTE @RC= [dbo].[usp_InsertLinkedServer] @ServerName ,@Alias ,@ECATDBName ,@Active ,@RemoteUser ,@RemoteUserPassword ,@Port ,@FK_LinkedServers OUTPUT ,@ErrorMessage OUTPUTGO
- After step 3 is executed successfully, execute the following stored procedure on the ECAT Primary Server:
Exec usp_PropagateMCSCredential
Notes
This article assumes there is in fact secondary servers associated with the deployment of the ECAT servers, otherwise, we don't expect to see this error.