I’'ve had some trouble getting Jive to work with SQL Server.
To start with, the SQL template for SQL Server causes 2 warnings when executing the script.
“Warning! The maximum key length is 900 bytes. The index ‘‘mucAffiliation__pk’’ has maximum length of 2052 bytes. For some combinations of large values, the insert/update operation will fail.”
This also happens on mucMember__pk
When a user tries to invite another user, the invited user doesn’'t receive the invitation.
I have tried reducing the specified length of the script from:
jid NVARCHAR(1024) NOT NULL
jid NVARCHAR(200) NOT NULL
Everything seems to work fine when using the HSQLDB database.++