-
Title
Database will not install on a SQL 2000 server -
Description
When trying to install the Database component on a SQL 2000 Server the following errors appear,
MsiExec.exe - Application Error: The instruction at "0x00a037a2" referenced memory at "0x014ce534". The memory could not be "read". Click on OK to terminate the program
and
Error: Runtime error 216 at 00A037A2 -
Resolution
Under the properties of the SQL 2000 Server if it states Server Collation: SQL_Latin1_General_CP1_CS_AS which means Case Sensitivity is enabled and the MessageStats Database component will not install.
The database component will only install on a SQL 2000 Server where Case Sensitivity is disabled. When Case Sensitivity is disabled then the Server Collation: SQL_Latin1_General_CP1_CI_AS means Case Insensitive and the database component will install.