Share via

HPC Pack 2016 - moving databases

Matt Barron 66 Reputation points
2022-02-16T16:31:16.24+00:00

I'm trying to move the HPC databases from the local, on the head-node instance of SQL Server Express to another database server.

I've backed up and moved the five databases, and updated the connections strings in the registry on the head-node. But what do I do about the user account? Do I need to add a service account that all the HPC services will run on and add that to the remote database?

I'm running HPC Pack 2016 Update 3.

Cheers,

Matt

Azure Virtual Machines
Azure Virtual Machines

An Azure service that is used to provision Windows and Linux virtual machines.

0 comments No comments

Answer accepted by question author

vipullag-MSFT 26,537 Reputation points Moderator
2022-02-21T11:23:14.047+00:00

@Matt Barron

Welcome to Microsoft Q&A Platform, thanks for posting your query here.

After the database movement, grant db_owner role to the following AD accounts for all HPC databases:

  1. The head node machine account.
  2. The HPC cluster administrator(s)

Hope this helps.
If the suggested response helped you resolve your issue, please 'Accept as answer', so that it can help others in the community looking for help on similar topics.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.