...
SQL Server Install Failure
Problem
When installing GlobalSearch 4.5.2 or older, or installing GlobalCapture 2.1.2 or older, the MS SQL Server installer may fail and you may receive an error like the one shown below. This can also occur when SQL Server and Active Directory exist on the same machine. It is not suggested that SQL and Active Directory exist in the same space, but in There are major issues that can arise as a result of installing SQL Server on a domain controller, please review the link from Microsoft that describes these issues. In the event that this cannot be avoided, follow the steps below.
...
Solution
During the install, at the Server Configuration, change the Account Name for the Database Engine to NETWORK SERVICE. If NETWORK SERVICE does not work, use NT AUTHORITY\SYSTEM. This will use a preset user to build the database properly.
...
IIS Components Are Missing In The Registry
...
When the GlobalCapture Engine Installer kicks off as part of the main Application installer, it will stall out or hang for over 20 minutes until it times out.
...
Common Cause
1. RDS server was not put into “Install Mode”. RDS servers have to be set to allow installs either from Control Panel or a CMD prompt.
2. The Group Policy for “Turn off Windows Installer RDS Compatibility” is either not set or Disabled. This policy when NOT enabled (see screenshot below) will prevent multiple Windows installers from running.
...
Proper Install Process
Set the server to install mode. I found the easiest way is to use CMD prompt as admin and type:
...
Creation of a Link Item Database Fails During Installation
...
On installation, you are prompted with this error before the installer fails out
| Info |
|---|
Error Message{"Message":"An error occurred while trying to create a new database: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified."} |
Solution
This is likely a missing file from the SQL Server that can be installed via a SQL Server feature pack. Normally this is packaged with the install, but you can download and run the feature packs from Microsoft's website to have the component reinstalled.
| Panel | ||
|---|---|---|
| ||
Download and install the Feature Pack for your version of SQL Server below. A restart may be required. |
...
SQL Server has a different Server Collation
Your previously installed instance of SQL may have a different collation than the installer is trying to write. The Green box on the left is the default US collation.
Solution: Install a new SQL named instance with the default US collation - SQL_Latin1_General_CP1_CI_AS.
See Microsoft article for more details.
...