SQL Error Code 10 - Software Pointing at Wrong Instance

Summary

This document shows you how to troubleshoot and resolve a SQL 10 error due to MyoVision software pointing at the wrong SQL Server instance.

Before you Begin

  1. Make sure the Windows account you are logged into has Administrator privileges or you have the Administrator login information.
  2. IMPORTANT: Make sure Windows 10 is fully updated before continuing.

How to resolve an SQL 10 Error due to an wrong Instance Name

1. Determine what SQL Server Instances are installed

Note: This step needs to be performed on the computer that contains the database. Generally it is the same computer that the exams are performed on, but it can be a different computer or server.

  • Open the MyoVision software, Setup > System > Database, click on Local Services

  • In the Services window, scroll down to SQL Server (xxxxx) services
    • Take note of the name in the parentheses "( )" if;
      • PBI_MYOVISION - This is the correct instance name to use in the MyoVision software for SQL Server 2014 and 2017
      • SQLEXPRESS - This may be the correct instance name if the MyoVision software uses SQL Server 2008. If no other instance names exist then this is likely the correct instance name to use in the MyoVision software. 
        • Note: This Instance Name is also used by ChiroTouch and other programs.


2. Check Database Name in MyoVision

  • Open the MyoVision software, Setup > System > Database

For Local Database:

  • In the Name field, verify that the Service Name after the backslash "\" is the same as the Instance Name determined in step 1
    • If MyoVision was installed using the default settings, the name will be one of the following;
      • (local)\PBI_MYOVISION
      • (local)\SQLEXPRESS
  • If the name does not match, highlight the name in the Service Name box and type in the correct name.
  • Keep " (local)\" in front of the instance name

For Network Database:

  • In the Name field; 
    • Verify that the Service Name after the backslash "\" is the same as the Instance Name determined in step 1
      • If MyoVision was installed using the default settings, the name will be one of the following;
        • PBI_MYOVISION
          or
        • SQLEXPRESS
    • Verify that the Computer Name before the backslash "\" is the name or IP address of the computer the database is located on.

3. Verify

Note: If you are still having trouble getting your MyoVision database to work properly, please feel free to contact our technical support at 1-800-969-6961, option 2 (8:30am - 4:00pm Pacific Time, Monday - Friday)  (+1 206-448-3464 International)