I must preface this to say that I have not done rigorous testing to determine if there are detrimental side-effects to the following process. I've used it a number of times and have not experienced abnormalities. But, as always, this is not endorsed by Citrix and your mileage may vary.
Use at your own risk!
- Close Desktop Studio.
- Stop Services
- Citrix AD Identity Service
- Citrix Broker Service
- Citrix Configuration Service
- Citrix Diagnostic Facility COM server
- Citrix Host Service
- Citrix Machine Creation Service
- Citrix Machine Identity Service
- Click the Start menu, type "cmd
"
Note: Different versions of SQLExpress store the sqlcmd command in different directories. It's easiest to use Windows Explorer to search C:\Program Files\Microsoft SQL Server for the correct location.
- Change to the binary directory where sqlcmd resides:
cd \Program Files\Microsoft SQL Server\100\Tools\Binn - Connect to the local SQLExpress database instance:
sqlcmd -S localhost\SQLEXPRESS - List the databases to determine the name of the database to drop:
sp_databases
go - Drop the database
drop database CitrixXenDesktopDB
go - List the databases again to validate it is no longer there:
sp_databases
go - Exit sqlcmd:
exit
- Start Services
- Citrix AD Identity Service
- Citrix Broker Service
- Citrix Configuration Service
- Citrix Diagnostic Facility COM server
- Citrix Host Service
- Citrix Machine Creation Service
- Citrix Machine Identity Service
When the services spin up the have a rude awakening because the database that existed when they shut down no longer exists. We now have to tell XD5 to start over.
- Open Desktop Studio
- On the "Specify the address of a Controller in the site you wish to administer" window select "This machine" and click OK
- Click Yes when prompted with, "The services are no longer permitted to access the configured database. Would you like to reset the services and retry?"
- Click "Desktop deployment" on the main Desktop Studio screen
- Complete the wizard as usual, with the exception of selecting "Use existing database" for the "Database configuration" element and leaving the default values.
- Click OK to automatically create the database