Symptoms
Creating the RSA database in MS SQL fails Note: The RSA database is required for Single Sign On (SSO) installation in vCenter Server 5.1. You see the error: Note: This example error occurred after trying to create RSA_DB with .mdf and .ldf files located on a compressed file system (the C drive, in this case). Create failed for Database 'RSA'. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The file "E:\RSA.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Create failed for Database 'RSA_DB'. (Microsoft.SqlServer.Smo)An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)The file "C:\RSA_DB.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5118)
Cause
Microsoft SQL Server databases are not supported on NTFS or FAT compressed volumes.Note: The preceding link was correct as of December 19, 2012. If you find a link is broken, provide feedback and a VMware employee will update the link.
Resolution
To work around this issue, create the RSA database on a volume that is not compressed. For more information, see Prerequisites for Installing vCenter Single Sign-On, Inventory Service, and vCenter Server in the VMware vSphere Install Guide.
To determine if the volume is compressed:
Click Start > Computer.Right-click the drive and click Properties.Click the General tab and check if Compress this drive to save space is selected.
Related Information
Installing vCenter Server 5.1 best practices
