Is that possible to migrate an existing database from one SQL server to another SQL server?
What will be the process?
Yes it is possible. Here is a step by step (assuming install was default options):
Core: Program Files\Palo Alto Networks\Endpoint Security Manager\Server
Console:Program Files\Palo Alto Networks\Endpoint Security Manager\Web\bin
***If no errors starting services, Start WWW Publishing services***
Things to consider:
Every CORE and CONSOLE has its own Hibernate file, and must be updated.
Thanks efrancis for the reply.
What about the database backup and restore process? Just backup and restore it to the new server? Is the regular process enough, or there are some details to take into account?
I have an issue with hibernate.cfg. We use 2 Traps servers; one in server vlan, one in DMZ. I moved the databases, configured a new connection to inside Traps server. My Traps server in DMZ connects through SQL account (and TrapsDB is on instance SERVERNAME\INSTANCE_NAME, listening on port 1433
firewall between Traps in DMZ and SQL server only allows port 1433.
I can connect through odbcad32, I tried all kinds of writing down SQL destination, but I cant start ESM service (in eventvwr: error in hibernate.cfg
If you are having issues starting the services because of hiberante file, I would recommend to open a case with support, who can assist making sure the migration was done correctly. There can be a few reasons why the connection fails when trying to start the services.
We have done this procedure, the only thing missing is to verify the instances, to start the services thanks for the help
Thank you!! We have done it in the version 4.2.4 and it works fine!
In our case the installation is with 2 cores and 1 console.
Thank all of you for this topic. It is really valuable knowledge.
I have another question about MSSQL usage: did someone ever try to use AWS-based MS SQL (Amazon RDS for SQL Server) instead of on-prem MS SQL? My ESM is built as AWS EC2 instance and it would be highly desirable not to use the server-based DN.
Best regards :)
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the Live Community as a whole!
The Live Community thanks you for your participation!