Configuring a Network Database in Your Office for MyoVision

Summary
Step 1: Make a Backup of Your Database - This step will guiding you through creating a backup of your current patient database.
Step 2: Install Software - This step will guide you through installing the MyoVision software. If you already have the MyoVision software installed you do not need to do this step.
Step 3: Migrate to SQL Server 2014 - In this step you will check to make sure that you are running SQL Server 2014. If you are not running SQL Server 2014, this step will also show you how to upgrade to SQL Server 2014. You only need to do this step if you currently have MyoVision installed on your computer.
Step 4: Setup Firewall - In this step you will setup the firewall, on the computer that you want to host the data on the network database.
Step 5: Final Server Setup - In this step you will setup the computer that you want to host the data so that the "workstation" computers can access the MyoVision database.
Step 6: Setup Workstation Computers - In this step you will setup the workstation computers so that they connect to the network database.

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 need to merge patient databases click here.

Use this method to create a copy of your MyoVision database using the built-in backup feature. When you create a database backup, the MyoVision software takes all of your patient and exam data and compresses it into a single file. These files are typically fairly small in size.

To begin making a backup: select File then Backup Exams.
A popup will appear. Select: (1) Where you want to save your backup to (2) Name your backup file, (3) Click Save to create the backup.
TIP: include the date the backup was created in the File Name. This will make it easier to recognize when the backup was created.
You will receive the following "Success!" message if your backup was completed properly.Once you have successfully created your backup file, you can transfer it to an external location such as a flash drive, external hard drive, another computer, or a server.

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.

Go to the MyoVision Software Download site.
Once at our website, click the Download Now button.
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.
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.

Under the Setup menu go down to Settings and select General.
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.

Go to your (C:) drive and open the WinScan98 folder.
Open the SSE2014 Folder
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

Choose the "New SQL Server stand-alone installation..." option.
On the next screen, choose the "Perform a new installation..." option. Then click the Next button.
The installer will then run it's checks. When it's done, left-click to check the box for "I accept the license terms."
At the Feature Selection screen click the Select All button then the Next button.
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.
At the Server Configuration screen, set the Startup type for the SQL Server Database Engine and the SQL Server Browser to Automatic.
Select the Mixed Mode option. For the password enter "MyoVision01".
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.
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.

In the Control Panel open up the Windows Defender Firewall
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.

In the Left Panel select Inbound Rules. Then, on the right select New Rules...
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
Select "Allow the connection," then click the Next button.
Check the boxes next to each option to apply the rule to all connections. Then, click the Next button.
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: 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.

Open the SQL Configuration Manager.
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.

Open the services menu.
Select the SQL Server service. Right-click the service and select the Restart option to restart the service.
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.

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.
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.”
Expand this list of folders by double-clicking on the folder and locate DOMAIN\Domain Users nested under Logins.
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 6: 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.

Open the Setup menu from the top menu bar, go down to Settings, and select General.
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.
On the Client (Workstation) Computers, open the MyoVision software, open the Setup menu, and select Database.
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.