Show/Hide Toolbars

Jim2® Business Engine Help File

Navigation: Jim2 Technical Knowledge Base > Jim2 Server > Jim2 Server Console

Move Jim2 to a New SQL Instance on the Same Server

Scroll Prev Top Next More

Below is a summary checklist of how to move  Jim2 to a new SQL instance.

 

The procedure assumes you have basic knowledge of the SQL Management, Jim2 Client and the Jim2 Server Console.

 

Migration Checklist

SQL Instance Setup

Install the new instance on the existing server (including Management Studio, if not already installed).

Ensure SQL TCP Protocol is enabled for the new instance via SQL configuration manager.

Update SQL Authentication to mixed, and update password policy, if applicable.

Enable SQL sa user, and update password as appropriate. (Store this information in a safe place, as Happen Business does not store this for you.)

Add an additional firewall rule to the new instance

Sqlservr.exe (usually found in: C:\Program Files\Microsoft SQL Server\MSSQL<version>.<instance_name>\MSSQL\Bin\ ).

See existing rule for reference.

 

Info

If you install SQL manually (not via the Jim2 Installer), you will need to ensure TCPIP is enabled via the SQL Server Configuration Manager:

 

tcpip protocols

 

If you install SQL Express 2016 manually, we recommend naming the instance JIM2.

 

Jim2 Migration

Ensure all users are out of Jim2.

Via the Jim2 Configuration Manager right click on the Jes Instance and select Stop Jes. This will also disable the sending and receiving of emails.

stop jes

Back up your database.

Via Jim2 Configuration Manager, Stop Jim2 Server Service.

Remove Jim2 Server Service.

remove server service

Add Jim2 Server Service and ensure it is pointing to the new instance name.

add server
new server instance

Right click configure Jim2 Server Service.

server service

Add the sa and password, then click Test.

Update DBWorking Directory if needed.

Start Jim2 Server Service

Restore the Jim2 backup, which will restore it to the new instance.

restore1

Start Jes.

new jes instance1

Start the Jes service.

Log on enable Email in Jim2.

Test with Jim2 Client on workstation and server.

Ensure the scheduled backup is configured via the Jim2 Server Manager.

 

 

Further information:

Back Up and Restore Database

Change the Name of Your Database

Change Next Object Number

Create a Training Database

How to Update Your Licence

Move Jim2 to a New Server

Remove an Old Database

Set up eBusiness Supply

What to do if Backup Drive is Full