SQL Server 2005 Express not supported for use with SoftGrid/App-V Virtual Application Servers

Because of the limitations of SQL Server 2005 Express it is not supported as a SQL server option for SoftGrid or App-V Application Virtual Servers. SQL Express doesn’t support the SQL Server Agent which means: 1.    The SoftGrid/App-V database clean-up and resizing jobs will not run causing the database to grow uncontrollably overtime to the […]

Because of the limitations of SQL Server 2005 Express it is not supported as a SQL server option for SoftGrid or App-V Application Virtual Servers. SQL Express doesn’t support the SQL Server Agent which means:

1.    The SoftGrid/App-V database clean-up and resizing jobs will not run causing the database to grow uncontrollably overtime to the maximum of 4Gb at which point the SoftGrid Service could fail and cause a server outage.
2.    The SoftGrid Management Console options to control database size and retention period for the metering data options will not work.

If you want a supported environment then you need to use either Microsoft SQL Server 2000 or Microsoft SQL Server 2005 for production Virtual Application Servers.

Source:→ App-V Blog