As stated here or here SQL Server 2012
is not a supported platform for Lync 2010
. Yet, is there any workaround?
Didn't find a full solution on the web, so will be posting one which should help some of the people that might face this situation.
Some cases should be solved simply by copying the msdb.sys.sp_dboption
stored procedure, from a previous version of SQL Server, into the master
database of SQL Server 2012
, and marking it as a system procedure so it can be executed on any database:
USE master
GO
EXEC sys.sp_MS_marksystemobject sp_dboption
There is still something more that can be done if the above is not enough - Install the SQL Server 2005 Backward Compatibility Components MSI (it includes the DMO feature)
32 bit, X86 Package - SQLServer2005_BC.msi 64 bit, X64 Package - SQLServer2005_BC_x64.msi
Best solution is still the one where you kept Lync 2010 running on SQL Server <= 2008R2 and didn't have to reach this page:)