Hi all,
One of my customer asked to me how to change Laserfiche SQL instance. I don't understand the question and don't know how to do. Someone can help?
Hi Oliver,
You can update the DBMS location for Laserfiche in the admin console of Laserfiche. Login to the repository and right click>All tasks>Change DBMS Connection...
Here you can set where Laserfiche looks for it's repository database.
Note that this is only for the Laserfiche core system, if you have other options such as Workflow and Forms you'll need to update those databases as well through the respective configuration points.
Hope this helps point you in the right direction!
Hi Oliver, the SQL Server Instance name should be setup like when you are setting up a new database or migrating databases to another server. You will want to start with SQL Server Installation Center and setup your SQL Server with a newly named instance. Keep the old one because you will just restore all the databases into the new instance.
You can even connect to two or more instances at the same time which makes it easier to work with them (the circled icon):
You will want to make sure that once you create the new instance, disconnect all LF services on all products so there are no DB changes, then migrate DBs and change all LF products to point to the new instance, then restart services. Your client's Laserfiche Desktop Client will have to be remapped too.
A tip: since you are going thorough the trouble, might as well ask your customer and start putting SSL on all LF products. there is a fantastic whitepaper that covers this.