Applies to
ApexSQL Log 2014
Summary
This article explains how to manually install and uninstall the server side components when it is not possible to utilize ApexSQL Log installer or when server side components need to be (un)installed on the passive cluster node.
Installing ApexSQL Log 2014 server-side components
When ApexSQL Log is installed in a cluster environment, the server side components cannot be installed on the passive nodes. To perform the installation of server side components in an environment that prevents installation from the ApexSQL installation wizard, the following steps need to be done:
Rename the copied file to ApexSQLLogXprocs.dll
IF NOT EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog' ) EXEC master.dbo.sp_addextendedproc 'xp_ApexSqlLog' ,'ApexSqlLogXprocs.DLL'
Copy following files from the ApexSQL Log installation folder to the target SQL server machine folder:
C:\ProgramData\ApexSQL\ApexSQLLog\\Binn\
Note: In case you are installing to default server instance (MSSQL), the ‘(local)’ must be used in place of the ‘ ‘ (e.g. C:\ProgramData\ApexSQL\ApexSQLLog\(local)\Binn\)
The files list:
ApexSQL.Activation.dll
ApexSQL.Base.dll
ApexSQL.Common.ArrayOfflineMetadata.dll
ApexSQL.Common.DdlAuditing.dll
ApexSQL.Common.Decry.dll
ApexSQL.Common.Dependency.dll
ApexSQL.Common.GrammarParser.dll
ApexSQL.Common.Logging.dll
ApexSQL.Common.OfflineMetadata.dll
ApexSQL.Common.Scripting.dll
ApexSQL.Diff.dll
ApexSQL.Engine.dll
ApexSQL.Log.Auditing.dll
ApexSQL.Log.CommunicationProtocol.dll
ApexSQLLogCorex64.dll or ApexSQLLogCorex86.dll (depending on the architecture)
ApexSQLLogServerAuditor.exe
ApexSQLLogServerHelperx64.exe or ApexSQLLogServerHelperx86.exe (depending on the architecture)
ApexSQLServerActivation.exe
atl90.dll
Microsoft.VC90.ATL.manifest
Microsoft.VC90.CRT.manifest
msvcm90.dll
msvcp90.dll
msvcr90.dll
This enables ApexSQL Log 2014 to audit the target SQL server and concludes the manual installation process.
Uninstalling ApexSQL Log 2014 server-side components
Execute the following SQL script:
-- Stop connection monitor IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor_Stop' ) EXEC master.dbo.xp_ApexSqlConnectionMonitor_Stop IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor2008_Stop' ) EXEC master.dbo.xp_ApexSqlConnectionMonitor2008_Stop IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2008ConnectionMonitor_Stop' ) EXEC master.dbo.xp_ApexSqlLog2008ConnectionMonitor_Stop IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2010ConnectionMonitor_Stop' ) EXEC master.dbo.xp_ApexSqlLog2010ConnectionMonitor_Stop IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLogConnectionMonitor_Stop' ) EXEC master.dbo.xp_ApexSqlLogConnectionMonitor_Stop -- Drop connection monitor xprocs -- 2005 IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor_Disable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor_Disable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor_Enable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor_Enable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor_Info' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor_Info' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor_Stop' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor_Stop' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlConnectionMonitor_Start' ) EXEC master.dbo.sp_procoption 'sp_ApexSqlConnectionMonitor_Start' ,'startup' ,'false' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlConnectionMonitor_Start' ) EXEC master.dbo.sp_executesql N'DROP PROCEDURE sp_ApexSqlConnectionMonitor_Start' -- 2008 IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor2008' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor2008' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor2008_Stop' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor2008_Stop' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor2008_Info' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor2008_Info' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor2008_Enable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor2008_Enable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlConnectionMonitor2008_Disable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlConnectionMonitor2008_Disable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlConnectionMonitor2008_Start' ) EXEC master.dbo.sp_procoption 'sp_ApexSqlConnectionMonitor2008_Start' ,'startup' ,'false' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlConnectionMonitor2008_Start' ) EXEC master.dbo.sp_executesql N'DROP PROCEDURE sp_ApexSqlConnectionMonitor2008_Start' -- 2008.05 IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2008ConnectionMonitor' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2008ConnectionMonitor' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2008ConnectionMonitor_Stop' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2008ConnectionMonitor_Stop' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2008ConnectionMonitor_Info' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2008ConnectionMonitor_Info' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2008ConnectionMonitor_Enable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2008ConnectionMonitor_Enable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2008ConnectionMonitor_Disable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2008ConnectionMonitor_Disable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2008ConnectionMonitor_State' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2008ConnectionMonitor_State' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlLog2008ConnectionMonitor_Start' ) EXEC master.dbo.sp_procoption 'sp_ApexSqlLog2008ConnectionMonitor_Start' ,'startup' ,'false' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlLog2008ConnectionMonitor_Start' ) EXEC master.dbo.sp_executesql N'DROP PROCEDURE sp_ApexSqlLog2008ConnectionMonitor_Start' -- 2010 IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2010ConnectionMonitor' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2010ConnectionMonitor' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2010ConnectionMonitor_Stop' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2010ConnectionMonitor_Stop' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2010ConnectionMonitor_Info' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2010ConnectionMonitor_Info' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2010ConnectionMonitor_Enable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2010ConnectionMonitor_Enable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2010ConnectionMonitor_Disable' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2010ConnectionMonitor_Disable' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLog2010ConnectionMonitor_State' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLog2010ConnectionMonitor_State' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlLog2010ConnectionMonitor_Start' ) EXEC master.dbo.sp_procoption 'sp_ApexSqlLog2010ConnectionMonitor_Start' ,'startup' ,'false' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'sp_ApexSqlLog2010ConnectionMonitor_Start' ) EXEC master.dbo.sp_executesql N'DROP PROCEDURE sp_ApexSqlLog2010ConnectionMonitor_Start' -- 2011 IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLogConnectionMonitor' ) EXEC master.dbo.sp_dropextendedproc 'xp_ApexSqlLogConnectionMonitor' IF EXISTS ( SELECT * FROM master.dbo.sysobjects WHERE NAME = 'xp_ApexSqlLogConnectionMonitor_Stop'
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center