Running Lync 2010 with a SQL Server 2012 Backend

Recently I was tasked with migrating all SQL 2008 R1 and prior databases to SQL 2008 R2 and SQL 2012.  One of my qualifying applications was Lync 2010.  We were under the impression that SQL 2012 would be fine for the Lync 2010 installation.  After migrating the database and updating the connections, Lync would not fully initialize.

After running a quick trace, I discovered that some of the Lync processes were calling sp_dboption.  SQL Server 2012 does not have this stored procedure any longer.  So to remedy the situation, I scripted sp_dboption from the system procedures on SQL 2008 R1 and manually created it on SQL 2012 as a user stored procedure.  After granting execute permissions to the user, Lync 2012 started right up.

We’ve been running on SQL Server 2012 for months without further issue.

Brandon has worked in IT for nearly 20 years, and currently serves as a SQL Server DBA for a healthcare company in California. In his spare time, he runs for miles and helps maintain Brandon is a certified SQL Server administrator.

Posted in Lync, SQL Server

Leave a Reply