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.
- Run the DbScript.exe located in the “C:Program FilesCitrixProvisioning Services” folder:
- After running the DbScript executable, select New Database along with the Script file name to be generated and other pertinent information such as Database name, Farm name, Site Name, Collection name, and Farm Administrator group, as displayed in the following screen shot:
- Save the script file that you will run against the SQL Server:
- Copy the script file that you had saved to a folder on your SQL Server.
- Run the script by double-clicking on it against the Master SQL DB to get the following screen:
- Click the Execute Script button, so that the Database is created automatically for you.
- Run the Provisioning Services Configuration Wizard and select Join existing farm, as displayed in the following screen shot:
- Proceed through the wizard selecting the pertinent details, as displayed in the following screen shots:
- When entering Store location, point to the Store location on the Provisioning Services Server:
Note: The account shown in the following screen shot is a Domain user added to the local Administrators group on the Provisioning Services server:
- Once the wizard completes, start the Desktop Studio with valid Credentials and your Provisioning Services Server will be ready for use.
Read the original article here.