tag:support.hglabhq.com,2012-10-18:/discussions/problems/70-error-when-installingHgLab: Discussion 2013-08-22T07:56:28Ztag:support.hglabhq.com,2012-10-18:Comment/252168522013-02-23T13:27:02Z2013-02-23T13:27:02Zerror when installing<div><p>Dean,</p>
<p>Thanks for reporting! I'll try to reproduce the issue.</p>
<p>Is this a fresh install on a newly created, empty database?</p></div>Anton Gogolevtag:support.hglabhq.com,2012-10-18:Comment/252168522013-02-24T05:14:52Z2013-08-13T16:17:05Zerror when installing<div><p>Yes, a brand new, empty database.</p></div>Deantag:support.hglabhq.com,2012-10-18:Comment/252168522013-02-28T11:43:11Z2013-02-28T11:43:11Zerror when installing<div><p>Dean, sorry for the long wait.</p>
<p>That's all very strange. Folks at DBA.SX say this is highly
unlikely: <a href=
"http://dba.stackexchange.com/q/35386/11154">http://dba.stackexchange.com/q/35386/11154</a></p>
<p>If you could try executing the offending SQL</p>
<pre>
<code>INSERT INTO [Setting]
([ID],
[Module],
[Property],
[Value])
VALUES ((SELECT COALESCE(max(ID), 0) + 1
FROM [Setting]),
N'security.catalogs.integrated.integrated',
N'enable-integrated-authentication',
N'true')</code>
</pre>
<p>in SQL Server Management Studio to see if this causes any
errors, that would be great.</p>
<p>Otherwise, we can schedule a TeamViewer session so that I could
debug this issue more thoroughly.</p>
<p>Thanks!</p></div>Anton Gogolevtag:support.hglabhq.com,2012-10-18:Comment/252168522013-03-01T09:31:54Z2013-03-01T09:31:54Zerror when installing<div><p>Dean,</p>
<p>Just to make sure you're really running under SQL Server 2008
R2: could you please show me the output of this command on your SQL
Server instance where <code>hglab</code> database is running:</p>
<p>select @@version</p></div>Anton Gogolev