I recently had to move a PVS farm that consisted of 4 servers from a Single Database instance to a SQL AG instance. I wasn’t 100% how to do this, so I reached John Carmody, aka @c4rm0. He sent me his blog as a reference. In this write-up, you will notice that there are very similar steps at a high level. I wanted to share my experience to confirm it does work, and I tried to add more details so that my blog and his blog should cover all questions that may arise. Again, I wanted to clarify that this isn’t a copy but more of my experiences with it and to back up the use case. 😊. The move to a SQL AG is around replicating the DB to a DR area and having the DB up for other DR requests around CVAD setup
Let's Start
In my situation, I had a Change Control in place, and I knew that I wanted to take an outage to do this. Therefore I am unsure if you can do this while maintaining uptime. Because the 4 PVS servers use the PVS database, it is hard to move the DB to an AG while the connections are ongoing from the PVS servers to the Database.
Stopping the Stream service on the PVS servers during the change achieve the same thing we don’t want connections to the PVS database while migrating the database
After stopping the services, here is a quick DB script they used to copy and restore the DB on the AG.
The process in action
Next, we will need to open the PVS configuration Wizard to reconfigure the Database parameters.
In this screenshot, you will need to update the AG connection and check “Enable MultiSubnetFailover for SQL Server Always On.”
The Site Farm name will appear once the connection is established again.
Select the exiting Site
Select the Existing Default Store
Select the Citrix Licensing Server that you are using. It should auto-fill from what you had before as well.
Enter your service account information here. SOAP services to keep things going.
I left this the default, as PVS manages my Computer accounts.
Select the Streaming Network Interfaces.
Select the other Servers for Steaming. Note: you will notice that I have 2 Servers here. Above I said I was moving 4 Servers, and 2 of them aren’t on this list. In my environment, I split the XA and XD into different PVS Servers for the environment Audit Requirement I have. There is just 2 of the server in this example.
Option here and check the settings in the Output text. Then start the services.
After this had been completed, I rebooted my PVS servers. I do this, and you don’t have to.
New Location
You can see my 01 servers are already picking up connections.
Then my 02 server is as well.
Then I rebooted one of the PVS targets to ensure it could be steamed and verified it registered in Studio.
The VDA is steaming as it should.
On 2 of my newer servers, I had this in the event logs. I knew what that was because I had dealt with this before. These needed the native SQL tools updated. Once this was done, the Stream process connected just fine.
Error in Event Logs
After installing the Native SQL Tools. The Services was good on 04
As you can see, this isn’t a complex process, and it is straightforward, and Citrix made this extremely easy, in my opinion. I hope this helps someone out there.
Thank you.
No comments:
Post a Comment