Installing Mirasys VMS and Microsoft SQL Express 2019 separately

Some cases there is need to install Mirasys VMS and Microsoft SQL Express 2019 separately.

1. First download latest Microsoft SQL Server Express 2019 installer from Microsoft site
   

   

2. Open Microsoft download tool and click Download Media button
   

   

3. Next window, select Express Advanced installation package and download location
   

   

4. When download is ready you can proceed to installation.

5. Double click installation media and wait that installer extract files.

6. When this is done you should see new window where option is to “New SQL Server stand-alone installation or add features to an existing installation”.
   

   

7. This open new window where you need accept license agreement.

8. Accept this and click Next.
   

   

9. Then wait that installation wizard is going to next window.

   1. On this time installation check if there is need reboot machine or install updates etc.

   2. There can be Warning related to Windows firewall. This indicate that if you want allow incoming connections from outside, you need to open ports for this. On normal case, this is not needed.

10. Click Next to proceed.
    

    

11. On next window, disable Machine Learning Services and Language Extensions.

12. Now you can also change installation locations if this is needed.

13. Click Next to proceed.
    

    

14. On default Mirasys VMS is looking for instance SQLEXPRESS from local server.

    1. If there is no need to change it, keep it default and click Next to proceed.

    2. If there is need to use external or different name, then use this guide to configure Mirasys VMS connections strings.
       

       

15. You can keep here default settings and click Next to proceed.
    

    

16. On this window is important that you add current user and NT AUTHORITY\SYSTEM user. If there is need to add other users which can access SQL Express server, those can be added now or later on using Microsoft SQL Management Studio.

    1. Mirasys VMS use SYSTEM user to create databases. If this is not added, then VMS can’t make needed databases.

    2. Enable also Mixed mode, this allows you login with sa-user with password and also with Windows authentication.

17. Click Next to proceed.
    

    

18. After this installation start installing Microsoft SQL Express server. Please wait, this can take few minutes.

19. When installation is done, you can close window clicking Close-button.
    

    

20. If there are any other windows open, you can also close them now.

To manage SQL Server, you need install Microsoft SQL Management Studio separately. 

To install Mirasys VMS, you need use update package. This does not include Microsoft SQL Express Server installation. Future updates are also done with Mirasys VMS Update package. 

If you use Mirasys VMS Complete package, this force installs Microsoft SQL Express Server older version which is included in installation package.