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

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




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 the following registry settings:


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 the following configurable options:

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.

You can also change the Database name here if required. 

 

In the PublishingService section you will find the following configurable options:

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 the following configurable options:

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.

You can also change the database name here if required. 

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).

Leave a Comment
  • Please add 4 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Danny van Dam edited Revision 9. Comment: corrected first sentence being displayed in smaller font

  • Danny van Dam edited Revision 8. Comment: made a few changes to the text

  • Maheshkumar S Tiwari edited Revision 7. Comment: Formatting

  • Maheshkumar S Tiwari edited Revision 6. Comment: Added TOC and formatting

  • Balaji M Kundalam edited Revision 4. Comment: Typography - minor edit

  • Danny van Dam edited Revision 2. Comment: added that database name can also be changed

  • Danny van Dam edited Original. Comment: type error correction

Page 1 of 1 (7 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Danny van Dam edited Original. Comment: type error correction

  • Danny van Dam edited Revision 2. Comment: added that database name can also be changed

  • Balaji M Kundalam edited Revision 4. Comment: Typography - minor edit

  • Maheshkumar S Tiwari edited Revision 6. Comment: Added TOC and formatting

  • Maheshkumar S Tiwari edited Revision 7. Comment: Formatting

  • Danny van Dam edited Revision 8. Comment: made a few changes to the text

  • Danny van Dam edited Revision 9. Comment: corrected first sentence being displayed in smaller font

Page 1 of 1 (7 items)