During installation, you may encounter the exception

Error -2147217900: failed to execute SQL string, error detail: Must declare the scalar variable "@timestamp


The main reason for this error is due to SQL server collation settings. We do not support case sensitive collation (this is the case for Microsoft BizTalk Server as well) http://technet.microsoft.com/en-us/library/dd879264(v=bts.10).aspx

 

So, you should ask your DBA to change the SQL server collation to one of the supported ones. The one in bold is what normally people will have


The exact list of supported collations is:

Chinese_PRC_CI_AS

Chinese_Taiwan_Stroke_CI_AS

Latin1_General_CI_AS

SQL_Latin1_General_CP1_CI_AS

Modern_Spanish_CI_AS

French_CI_AS

Japanese_CI_AS

Korean_Wansung_CI_AS