I recently ran into a problem installing Service Manager SP1. In my lab a while back I successfully created two Hyper-V/VMM VMs each using the default 40GB disk. I then installed SQL 2012 on both of them installing all of the SQL features and options. I installed the SM SP1 Beta Service Manager Management Server portion pointing to the local version of SQL. I then installed the SM SP1 Beta Data Warehouse Management Server portion pointing to the local version of SQL. During setup of the SM SP1 Beta Data Warehouse Management Server I did receive some errors in setup that there was not enough space to install the databases. I had to scale down the size of each DB from 2GB to 1.5GB to get past the error. I was able to install it successfully.
Since Service Manager does not have an upgrade path from SP1 Beta to SP1 I decided to just blow away both VMs and start all over again. I once again created two Hyper-V/VMM VMs each using the default 40GB VHDX. I then installed SQL 2012 on both VMs installing all the SQL features and options. I was successful in installing the Service Manager Management Server on the first server just like SP1 Beta. I was NOT successful on installing the Service Manager Data Warehouse Management Server on the second server. I would receive an error during setup of:
An error occurred while executing a custom action:_CreateDatabase
This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the correction are made, you can retry upgrade for this role.
What was interesting was in SP1 I did not receive errors in setup telling me setup can’t continue due to not enough free space for the databases. It turns out even though setup says there is enough free disk space there is not. Remember how I said during the install of SP1 Beta setup barked about not enough free disk space for the DBs using a 40GB VHDX but SP1 did not bark at the same point using a 40GB VHDX? Well to prove this I had to rely on a VM and snapshots.
I created a new VHDX in Hyper-V/VMM using the default 40GB disk. I then installed SQL 2012 and created a snapshot. I went through the setup of Service Manager SP1 Beta (Data Warehouse Management Server) including the error of not enough free disk space for the databases. I made the databases smaller and SP1 Beta installed. I then went back to my snapshot and did an install of SP1. During setup it did not bark that there was not enough free disk space like SP1 Beta did and I received my error while creating my databases. I then went back to my snapshot, INCREASED MY DISK, and went back through the setup of SP1 and it worked.
I strongly believe that setup in SP1 does not calculate the free disk space properly during setup and SP1 Beta does.
Below are some screenshots showing why I believe this.
Not enough free disk space for the CM Data mart DB
I went back and decreased the size of the DBs from 2GB to 1.5GB
Now there is enough free disk space.
Setup completed successfully.
Notice how there were no errors about not enough free disk space but setup failed.
I went back to my snapshot, increased my free disk space, and installed SP1 again.
Setup completed successfully
Of course you shouldn’t install SM like this or with this little disk space on SQL but it does bring up possible how to resolve this issue during setup.