This article will walk you through the steps to check if your MyoVision software is pointing at the write SQL Server instance. If you already have SQL Server 2014 installed and you know that it is running, but you are still getting Error Code 10, this article is for you.
Before You Begin
- Your instance of SQL Server may be named SQLEXPRESS or PBI_MYOVISION, depending on when you first installed the MyoVision software.
- Check to make sure you have logged in as an administrator on your computer. If you are unsure, follow the instructions on this site to find out. Are you an Administrator?
1. Open Services
Open the start menu and in the search bar type Services.
If you are on Windows 10, once the start menu is open you can just start typing Services and it will bring up a list of results. Alternatively you can use Cortana to search for services.
Select the Services program.
2. Check SQL Server Instance Name
In the Services window, scroll down to SQL Server (SQLEXPRESS) or SQL Server (PBI_MYOVISION). Most users will only have one instance, not both as shown in the example.
Take note of the name in the parenthesis.
3. Check MyoVision Software
In the MyoVision Software, check what instance your software is using to locate your database.
- Click Setup
- Choose Database
4. Check Service
For Local Database:
- In the Database Setup window verify that the Service is the same name as the SQL Server instance in Step 2.
- If the name does not match, highlight the name in the Service box and type in the correct name.
- Keep " (local)\ " in front of the instance name
For Network Database:
- If your database is on a network, point the service to the SQL Server instance running on your office server.
Click Test DB to check if you have successfully connected to your database.
If successful you will get Test connection succeeded.