Thursday, January 6, 2011

Quick note about defining a New SQL Store in Microsoft Lync Server 2010

Though this isn’t much of a surprise but I noticed that whenever you make a change for the SQL store under the Associations section for your pool in Microsoft Lync Server 2010’s Topology Builder, a new node representing the created SQL store will be created. 

image

This means that if you’re troubleshooting an issue during the initial setup and end up changing the SQL store multiple times then back to one that you’ve used before without deleting the it from the Lync Server 2010 tree, you’ll end up getting the following error:

A SQL Store named ‘SQLInstanceName’ already exists in pool ‘sqlServer.domain.com’

image

Also, if you try to delete a SQL store that’s currently assigned to a pool, you’ll receive the following error message:

This SQL store is being used. Remove the dependencies before deleting the store. Affected services:

Roles ‘UserServices, ApplicationServer, CentralMgmt’ on pool ‘poolName’

image

Yes, it’s not exactly that complicated or surprising but in case anyone new to Lync is wondering why they see these errors, the reasons outlined are why.

No comments: