Yesterday I have to repro cases from OCS, so the point is I have to move OCS DB to another server and I found this link : http://technet.microsoft.com/en-us/library/dd572422(v=office.13).aspx

I’ve already tried it on my lab and it works, but at my customer I failed so I have to rollback Sad smile.

Here’s the error when I want to Create Enterprise Pool

clip_image001

So after searching the internet and found KB from MS http://support.microsoft.com/kb/961944 and execute it but still the process won’t go.

With help from DBA and SQL Profiler to trace down what happen, it actually quite simple Smile. The Admin OCS lack of privilege in SQL Backend Server, so MS state when move the OCS DB it needs permission as member of RTCUniversalServerAdmins group, but the answer is it need sysadmin server role in the SQL Backend Server too!

Happy moving! Open-mouthed smile

Advertisements