Configuring a Network Database in Your Office for MyoVision

Table of Contents:

Summary:

This article will walk you through the necessary steps to setup a networked database for your MyoVision software. A networked database will allow you to access the database of patients and exams on any computer running MyoVision, connected to your network.

  • It is crucial that you backup your patient database before continuing with setting up your networked database.
  • You must have Administrative access to the server computer and workstations in order to setup a networked database.

When creating a network database one computer will be used as the Master computer that stores data (a network database has one computer that stores data and other computers that store data and receive data from the Master). Each computer that connects to the Master or Server computer will be designated as a Remote or Client computer.


Step 1: Make a Backup of Your Database

It is crucial that you follow these steps to backup your patient database within the software as well as backup the raw database files to properly restore your exams once the networked database has been setup.

If you will merging multiple, existing, patient databases together onto the Master computer, you will need to use Method 3: Export Patient Data, on all the computers that will be connecting to the network database.

Only use one of the Methods listed below. Write down the Method you used, when you go to restore your data you will need to use the Method Number that corresponds to the Method you used to backup your data.

Click through the tabbed options below to view different ways to backup:

Method 1: Backup Tool

The first method that you can use to backup your data is the backup feature that's built into the MyoVision software.

  1. To begin making a backup select File then Backup Exams.

  2. Inside of the Window that opens select: (1) Where you want to save your backup to (2) The File Name you want to give to your backup file, (3) Click Save to create the backup. 

  3. If you get the following message after selecting Save then your backup was successful.

Method 2: Create Copies of Raw Database Files

The second method of backing up your MyoVision data is to create copies of the raw files that MyoVision saves the database in.

  1. In addition to creating a backup file through the MyoVision software, you can create a copy of the raw database files from SQL Server.
  2. Navigate to the DATA Folder in SQL Server.

  3. In the DATA folder select both the MyoVision and the MyoVision_log files and right click. (Hold CTRL down on the keyboard to select both at the same time.)

  4. Navigate, inside of File Explorer, to where you saved your backup using the MyoVision software. Then, right-click and select "Paste," to place a copy of the raw files into the same location.

Method 3: Export Patient Data

The last method is use the built-in Export feature to make copies of all your patients and exams. By exporting patient data you can merge multiple databases onto the Master computer that will be storing MyoVision data for the network database.

  1. Open the File menu, go down to Export, and select the Data File option.
  2. Hold down the Shift key on the keyboard, click on the patient at the top of the list, scroll down and click on the patient of the bottom of the list, then release the Shift key. This should select all patients in your database. Then click the button marked with three ellipses "..." to set the location your database will be exported to.Once you have selected the export location click OK.

  3. Click the Export button to export your patient database.


Step 2: Install Software

In this next step we are going to be installing the MyoVision software on your workstation computers and on your server computer. If you already have MyoVision installed on your computers you can move to Step 3: Migrate to SQL Server 2014

2.1 Download and Run the Install File

The next step is to install the MyoVision software on any computers that you would like to have access to the Network Database that don't currently have the software installed.

  1.  Go to the MyoVision Software Download site.
  2. Once at our website, click the Download Now button.

  3. Once the file finishes downloading, navigate to your Downloads folder. Right-click the install file and select Run as administrator. When the computer asks if your would like to make changes to this computer select Yes.

  4. Press Next through the prompts in the install program until the installer has finished.Repeat the installation process for all computers that will be networked together.

2.2 Enable Remote Data

All Client computers need to follow the steps below to be able to send and receive data to the Master computer on the Network Database.

  1. Under the Setup menu go down to Settings and select General.
  2. Open the << Advanced tab. Check the box for "Use SQL remote data".

Tutorial Video: Download and Install Software


Tutorial Video: Use SQL Remote Data


Step 3: Migrate to SQL Server 2014

In order for your database to function properly the SERVER must be running Microsoft SQL Server 2014. If you did a fresh install of the MyoVision software on the server computer than Microsoft SQL Server 2014 is already installed. However if you were updating from a previous version you might still be running Microsoft SQL Server 2008 R2. Generally speaking if the SQL Server is called SQLEXPRESS you are running Microsoft SQL Server 2008 R2. If the SQL Server is called PBI_MYOVISION you are running SQL Server 2014.

3.1 Verify Whether You Are Running SQL Server 2014

The easiest way to check is by going to the Microsoft SQL Server folder and reading the folders.

  • Navigate to the Microsoft SQL Server folder through Program Files (x86)
  • MSSQL10 is an older version of SQL Server. If you are running this version move to Step 3.2 Run the Setup File.
  • MSSQL12 is SQL Server 2014. If you are running this version move to Step 4: Setup Firewall (SERVER COMPUTER ONLY)



3.2 Run the Setup File

The first step in Migrating to SQL Server 2014 is to run the Setup file.

  1. Go to your (C:) drive and open the WinScan98 folder.

  2. Open the SSE2014 Folder

  3. Right-click the Setup file and select the "Run as administrator" option.

3.3 Install SQL Server 2014

It is critical that you follow these steps, as shown, to ensure your SQL Server is installed properly

  1. Choose the "New SQL Server stand-alone installation..." option.

  2. On the next screen, choose the "Perform a new installation..." option. Then click the Next button.

  3. The installer will then run it's checks. When it's done, left-click to check the box for "I accept the license terms."

  4. At the Feature Selection screen click the Select All button then the Next button.



  5. After the installer loads the Instance Configuration screen, choose the option for Named Instance and type in PBI_MYOVISION. Then click Next to continue.
    Note: The Instance ID should auto-populate with the same name.


  6. At the Server Configuration screen, set the Startup type for the SQL Server Database Engine and the SQL Server Browser to Automatic.

  7. Select the Mixed Mode option. For the password enter "MyoVision01".

  8. Follow the Next set of steps to set the SQL Server Administrators. 
    Click the Add... button. Under the Enter object names box, click the Advanced... button. The Select Users window will open, click the Find Now button to view the list of available object. In the list that populates below you will need to look for users.
    Customers setting their network database up on a domain will need to select DOMAIN\users.

  9. Wait for the installation to finish. Once it has completed the installation, click Close.

Install SQL Server 2014

 


Step 4: Setup Firewall (SERVER COMPUTER ONLY)

This step allows the SQL Server to communicate through the server computer's firewall.

Step 4.1 Navigate to Windows Firewall

First we're going to navigate to the Firewall settings inside the Control Panel.

  1. In the Control Panel open up the Windows Defender Firewall

  2. Next click on Advanced Settings.

4.2 Create a New Rule

Once you've located the firewall settings, the next step is to create new permissions for the SQL Server and SQL Server Browser.

  1. In the Left Panel select Inbound Rules. Then, on the right select New Rules...

  2. Select Program then Next.Enter the pathway to the program.

    Open up the Services window by searching for Services from the Windows Start Menu. Right click on SQL Server (PBI_MYOVISION) and select Properties. Copy the path to executable. Only copy what is inside the quotation marks.

    Once you have it copied, paste the pathway in the Windows Firewall. Be sure to delete the quotation marks and any characters outside of them.
    The pathway should start with C:\ and end with .exe


  3. Select "Allow the connection," then click the Next button.

  4.  Check the boxes next to each option to apply the rule to all connections. Then, click the Next button. 

  5. Enter "MyoVision Server" as the name. Click the Finish button.
    (SERVER COMPUTER ONLY) Repeat Steps 1 through 6 (Step 4.2) for the SQL Server Browser listed under Services. When you reach Step 6 name the rule "MyoVision Server Browser". 

Creating Firewall Permissions


Step 5: Restore and Attach Database Files

If you do not have a database to restore, skip to Step 6. When restoring data make sure that you are restoring or merging your databases on the Master computer.

If you backed up your database in Step 1, we will now restore your Backup. You can restore your data from inside the software (Step 5.1 and 5.2) or by manually copying and pasting the raw database files into the DATA folder.

When merging databases together make sure to import all the files exported from Step 1 onto a single computer. This will ensure that all the computers on the network have access to you patient database.

You will want to follow the method with the same number as the backup method you used in  Step 1.

Method 1: Restore Tool

If you used the Backup tool in Step 1, then you will want to use the Restore tool to restore the *.bu2 that MyoVision saved your backup as.

  1. Open the Setup menu and select Database.


  2. Open the Advanced tab.

  3. Click the Attach button. When the Alert pops up select Yes to continue. In the Attach MyoVision data file window, navigate to C:\ProgramFiles(x86)\Microsoft SQL Server\MSSQL12.PBI_MYOVISION\MSSQL\DATA folder. Select the MyoVision.mdf file and click open. The software should tell you that the data file has successfully been attached.If you are unable to locate the MyoVision.mdf file, open windows file explorer and navigate to the folder C:\WinScan98\SSE2014\ and find the MyoVision.md and MyoVision_log.ldf files. Right-click them and select Copy.

    Then navigate to C:\ProgramFiles(x86)\Microsoft SQL Server\MSSQL12.PBI_MYOVISION\MSSQL\DATA, right-click and select Paste.

  4. Open the MyoVision software and open the File menu. Then, select the Restore Exams option.

  5.  The warning pop-up will appear letting you know that restoring a clears out the current database before restoring to the backup version of the database.
  6.  Navigate to the database file created in Step 1.1, Left-click the file to select it and click the Open button.
  7.  Click OK in the warning message box to restore the backup created in Step 1.1.
  8.  You will receive a prompt letting you know whether or not the restore was successful. 
  9. Open an exam to verify that the database restore was successful.

Method 2: Paste The Copies of Raw Database Files

If you manually exported your Patient and Exam data in Step 1, you will want to use the Import feature to restore your data.

  1. Locate the raw files that we copied in Step 1..2 in File Explorer. While holding down the CTRL key on the keyboard, left click both "MyoVision" and "MyoVision_log" files to select both of them. Then right-click on the files and select "Copy"
  2. Navigate to "C: > ProgramFiles(x86) > Microsoft SQL Server > MSSQL12.PBI_MYOVISION > MSSQL > DATA" inside of File Explorer. Then right-click and select "Paste"
  3. Open the Setup menu and select Database.


  4. Open the Advanced tab.

  5. Click the Attach button. When the Alert pops up select Yes to continue. In the Attach MyoVision data file window, navigate to C:\ProgramFiles(x86)\Microsoft SQL Server\MSSQL12.PBI_MYOVISION\MSSQL\DATA folder. Select the MyoVision.mdf file and click open. The software should tell you that the data file has successfully been attached.If you are unable to locate the MyoVision.mdf file, open windows file explorer and navigate to the folder C:\WinScan98\SSE2014\ and find the MyoVision.md and MyoVision_log.ldf files. Right-click them and select Copy.

    Then navigate to C:\ProgramFiles(x86)\Microsoft SQL Server\MSSQL12.PBI_MYOVISION\MSSQL\DATA, right-click and select Paste.

Method 3: Import Patient Data

This method is used when you need to merge databases together. When importing patient data files old data will not be erased.

  1. Open the Setup menu and select Database.


  2. Open the Advanced tab.

  3. Click the Attach button. When the Alert pops up select Yes to continue. In the Attach MyoVision data file window, navigate to C:\ProgramFiles(x86)\Microsoft SQL Server\MSSQL12.PBI_MYOVISION\MSSQL\DATA folder. Select the MyoVision.mdf file and click open. The software should tell you that the data file has successfully been attached.If you are unable to locate the MyoVision.mdf file, open windows file explorer and navigate to the folder C:\WinScan98\SSE2014\ and find the MyoVision.md and MyoVision_log.ldf files. Right-click them and select Copy.

    Then navigate to C:\ProgramFiles(x86)\Microsoft SQL Server\MSSQL12.PBI_MYOVISION\MSSQL\DATA, right-click and select Paste.

  4. Open the File menu, go down to Import, and select Files from Folder.

  5. Select the folder that you previously exported your patient data files to in Step 1. Then, click the OK button to import.

  6. When the software is done importing you will want to verify that all your data was merged.


Step 6: Final Server Setup:

In this step we will be finishing the setup of the networked server, by adjusting the TCP/IP settings and Permissions.

6.1 TCP/IP Setup

In order for other computers to access the data on this computer over the network the computer the service must be configured to Enabl TCP\IP connections.

  1. Open the SQL Configuration Manager.
  2. Select "Protocols for PBI_MYOVISION". Right-click TCP/IP, then select Enable.

After changing the setting Windows will alert you that in order for the change to take affect you will need to restart the service.

  1. Open the services menu. 

  2. Select the SQL Server service. Right-click the service and select the Restart option to restart the service.

  3. Repeat Step #2 for the SQL Server Browser service.


6.2 Set Permissions (DOMAIN USERS)

Only users that are setting up a network database on a domain should follow the steps below.

  1. Open Microsoft SQL Server Management Studio Express.

    If you do not have Microsoft SQL Server Management Studio Express head to Microsoft's website to download and install it.

    “Server Name” will automatically be filled in based on information from your computer. If you have multiple SQL Server instances on your computer you may need to change the ending of the Server Name to your instance name. PBI_MYOVISION and SQLEXPRESS are the two possible names for your MyoVision instance.

  2. You will be at a window with a list of files running down the left-hand side. Locate the second folder from the top says “Security.”
  3. Expand this list of folders by double-clicking on the folder and locate DOMAIN\Domain Users nested under Logins.
  4. Double-click Domain Users and then select Server Roles, then Check the box next to sysadmin as seen below. Click OK.

Tutorial Video: TCP/IP Configurations


Step 7: Setup Workstation Computers

Now that your server is setup and broadcasting the final step will be to check and make sure that it's broadcasting to your workstation computers and can successfully connect.

  1. Open the Setup menu from the top menu bar, go down to Settings, and select General.
  2. When the General Settings window opens, click the Advanced button to view the Advanced option. Then, make sure the Use SQL remote data. Click OK to save the setting.
  3. On the Client (Workstation) Computers, open the MyoVision software, open the Setup menu, and select Database.
  4. In the window for Service type in the address to the SQL server instance on the server. It will be SERVER\PBI_MYOVISION where SERVER is the name of your server.

    Select Mode 2 and fill in the login information
  • User Name : sa
  • Password: MyoVision01

Once the information is entered click on Test DB. If successful you will get Test connection succeeded.