This article describes how to manually create a database for Provisioning Services when the database administrator prefers to create the database manually.

Requirements

• The DbScript.exe file located in “C:\Program Files\Citrix\Provisioning Services”.

• SQL Database Server.

• SysAdmin privileges to run this script properly.

• Add the account utilized by the Soap and Stream to the local admin group on the Provisioning Services server.

Instructions

1. Run the DbScript.exe located in the “C:\Program Files\Citrix\Provisioning Services” folder.

   

2. 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.

   

3. Save the script file that you will run against the SQL Server.

   

4. Copy the script file that you had saved to a folder on your SQL Server.

5. Double click to run the script against the Master SQL DB to get the following screen:

    

6. Click the Execute Script button and the Database is created automatically.

7. Run the Provisioning Services Configuration Wizard and select Join existing farm.

   

8. Proceed through the wizard selecting the pertinent details.

   

    

    

9. 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: 

   

    

   

   

   

   
   
   

10. When the wizard completes, start the Provisioning Service Console with valid credentials.