Article Content
Article Number | 000033899 |
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:
DECLARE @RCINT DECLARE @ServerNameNVARCHAR(100) DECLARE @AliasNVARCHAR(50) DECLARE @ECATDBNameVARCHAR(50) DECLARE @ActiveBIT DECLARE @RemoteUserNVARCHAR(50) DECLARE @RemoteUserPasswordNVARCHAR(50) DECLARE @PortINT DECLARE @FK_LinkedServersINT DECLARE @ErrorMessageNVARCHAR(2048) -- TODO: Set parameter values here. EXECUTE @RC= [dbo].[usp_InsertLinkedServer] @ServerName ,@Alias ,@ECATDBName ,@Active ,@RemoteUser ,@RemoteUserPassword ,@Port ,@FK_LinkedServers OUTPUT ,@ErrorMessage OUTPUT GO
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. |