How to manually create a database for Provisioning Service

This article describes how to manually create a database for Provisioning Services since in some production environments the database administrator prefers to create the database manually.


You must utilize the DbScript.exe file located in “C:Program FilesCitrixProvisioning Services” and then run the script against the SQL server that your Provisioning Services Farm utilizes. Note: You must have SysAdmin privileges to run this script properly. If you encounter any issues when running the Provisioning Services Console after creating, add the account utilized by the Soap and Stream to the local admin group on the Provisioning Services server.

Procedure Continue reading “How to manually create a database for Provisioning Service”

SQL Server 2008 R2: Unlock the Locks

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem that seems like something else that can make troubleshooting all the more difficult and frustrating. Other times, the answer you’re looking for is staring you right in the face. This is the case with SQL Server 2008 R2, which has a known locking issue you can resolve by simply applying the latest service pack or update. Continue reading “SQL Server 2008 R2: Unlock the Locks”