App-V: Pre-creation of Server objects may yield certain sub-optimal values in SQL Database

Often, App-V administrators will leverage multiple App-V Management Servers sharing common database. The process usually involves pointing additional server to existing SQL server and database during installation. Key databases values that govern server behavior will be stored in DBO.SERVERS and DBO.SOFTGRID_SERVERS tables. These settings can also be configured using App-V MC (navigating to Application Virtualization […]

Often, App-V administrators will leverage multiple App-V Management Servers sharing common database. The process usually involves pointing additional server to existing SQL server and database during installation. Key databases values that govern server behavior will be stored in DBO.SERVERS and DBO.SOFTGRID_SERVERS tables. These settings can also be configured using App-V MC (navigating to Application Virtualization Systems-<hostname of App-V Management Service front-end to SQL data store> - Server Groups - <Name of server group> and then right-clicking that group and selecting “New Application Virtualization Management Server.”). This allows you to pre-create a server object with specific values configured in advance. This allows for smoother deployment of App-V server farms for high availability. When you pre-create a server object using the wizard, you’ve option of setting following values: Display Name, DNS Host Name, Memory Allocation, RTSP Security/Certificate, RTSP/RTSPS Port. During installation of additional App-V server (matches the DNS hostname,) an administrator will point to existing database and corresponding server record will also be slightly modified. “For the reasons mentioned, it’s recommended that you bypass server pre-creation and have server installation process create the server record. If you find your App-V server environment is already in this inconsistent state, you can modify these values to reflect the recommended default values using SQLCMD or SQL Management Studio,” Steve Thomas.