App-V 5.0 SP1 change SQL server name, SQL instance name or services port number #TNWiki

This post is also available on the TechNet Wiki:

http://social.technet.microsoft.com/wiki/contents/articles/18457.app-v-5-0-sp1-change-sql-server-name-sql-instance-name-database-name-or-services-port-number.aspx

 

In my scenario I needed to change the SQL Server name that was configured for my App-V 5 SP1 management service and reporting service for a SQL server migration.

The database administrator made sure that the copy of both databases maintained all access rights

So after the new SQL server is online go to the App-V Server hosting your Management and/or Reporting service.

(If you have multiple App-V servers then you will need to change this on all the servers hosting the management or reporting service)

 

The configuration settings are stored in:

HKEY_LOCAL_MACHINE\Software\Microsoft\AppV\Server\ManagementService

HKEY_LOCAL_MACHINE\Software\Microsoft\AppV\Server\PublishingService

HKEY_LOCAL_MACHINE\Software\Microsoft\AppV\Server\ReportingService

 

In the ManagementService section you will find:

INSTALLDIR (c:\Program Files\….)

MANAGEMENT_ADMINACCOUNT (MyDomain\Appv-Admins)

MANAGEMENT_ADMINACCOUNT_(SID S-1-……….)

MANAGEMENT_ADMINACCOUNT_TYPE (0)

MANAGEMENT_CMDLETS_URL (http://localhost:8080/ )

MANAGEMENT_CONSOLE_URL (http://localhost:8080/Console.html )

MANAGEMENT_DB_NAME (AppvManagement)

MANAGEMENT_DB_SQL_INSTANCE (infra_services)

MANAGEMENT_DB_SQL_SERVER (sqlserver1\infra_services)

MANAGEMENT_DB_SQL_SERVER_NAME sqlserver1

MANAGEMENT_SQL_CONNECTION_STRING (metadata=res//*//AppvManagement.csdl|……)

MANAGEMENT_WEBSITE_NAME (Microsoft App-V Management Service)

MANAGEMENT_WEBSITE_PORT (8080)

 

In the example listed above my SQL server was named “sqlserver1” and the instance “infra_services”. The management service was configured on port 8080. To change the SQL server you will need to update the MANAGEMENT_DB_SQL_SERVER key and the MANAGEMENT_DB_SQL_SERVER_NAME key.

 

To change the port number for the Management Service you will need to update all keys containing the current port number (8080 in this example). Do not forget to also update the PUBLISHING_MGT_SERVER key listed in the PublishingService section.

 

 

In the PublishingService section you will find:

INSTALLDIR (C:\Program Files\……)

PUBLISHING_MGT_SERVER (http://localhost:8080 )

PUBLISHING_MGT_SERVER_REFRESH_INTERVAL (600)

PUBLISHING_MGT_SERVER_TIMEOUT (100)

PUBLISHING_WEBSITE_NAME (App-V Publishing Service)

PUBLISHING_WEBSITE PORT (8081)

 

To change the port number for the Publishing Service you will need to update the PUBLISHING_WEBSITE_PORT key containing the current port number (8081 in this example). If you also changed the Management Service port number then also update the PUBLISHING_MGT_SERVER key with the new Management Service port number.

 

 

In the ReportingService section you will find:

INSTALLDIR (C:\Program Files\……)

REPORTING_DB_NAME (AppVReporting)

REPORTING_DB_SQL_INSTANCE (infra_services)

REPORTING_DB_SQL_SERVER (sqlserver1\infra_services)

REPORTING_DB_SQL_SERVER_NAME sqlserver1

REPORTING_SQL_CONNECTION_STRING (Data Source={0)……..)

REPORTING_WEBSITE_NAME (Microsoft App-V Reporting Service)

MANAGEMENT_WEBSITE_PORT (8082)

 

In the example listed above my SQL server was named “sqlserver1” and the instance “infra_services”. The Reporting service was configured on port 8082. To change the SQL server you will need to update the REPORTING_DB_SQL_SERVER key and the REPORTING_DB_SQL_SERVER_NAME key.

 

To change the port number for the Reporting Service you will need to update the REPORTING_WEBSITE_PORT key containing the current port number (8082 in this example)