Configuring a Network Database in Your Office for MyoVision

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.

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

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.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

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.
   

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