Applies to: All version of Centrify DirectAudit on all Windows platforms
The SQL server bundled with the DirectAudit install may fail on a Windows machine.
What are the conditions where this could happen?
The known error codes could be one of the following:
- 0x84B40000 - full text service cannot run under local system account on DC.
This means user is trying to install SQL Server on a Domain Controller with Full Text Search service configured under a local system account. This is not supported by Microsoft.
Workaround is to either install SQL on a member server, or manually install SQL and select a different account to run it as Full Text Search service.
For this error code, more information is needed, see below on how to collect logs.
If SQL server is already installed on a machine with default SQL server instance (with advanced services), the SQL server setup will fail with the above error code.
To workaround this issue, reinstall SQL Native Client (SNAC) before installing the second instance of SQL Server 2005 Express Edition with Advanced Services.
- http://msdn.microsoft.com/en-us/sqlserver/ff658533 (Provided as a courtesy)
This means a hyphen (-) in the SQL server's instance name has been specified and is not allowed.
SQL Server Management Studio 2005 has been installed on the system and there is an attempt to install SQL 2008 on top of it.
To workaround this issue, manually uninstall SQL Server Management Studio and then install the later version.
PowerShell 2.0, which is a prerequisite for Microsoft SQL server 2014, is not installed.
Install Windows Management Framework 2.0 first before run Report Services Configuration Wizard
SQL Server 2008 R2 express edition with advanced features will fail to install an new instance when TLS 1.0/1.1 and SSL 3.0 protocols are disabled. It fails with message like:
SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
To workaround this issue, re-enable the protocols (Update corresponding values to 1.) the SQL server instance then can be installed successfully.
Refer to: https://blogs.msdn.microsoft.com/friis/2016/07/25/disabling-tls-1-0-on-your-windows-2008-r2-server-just-because-you-still-have-one/
=== If SQL Server fails for any other reason ===
Send the install logs to Support.
Setup file locations:
- SQL Server 2005:
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG
- SQL Server 2008 and 2008 R2:
%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG
See also: http://support.microsoft.com/kb/955396