When opening M/Docs II, you receive the following error:

n attempt to attach an auto-named database for file for (Network Path)\MDocsII\Database\MDMain-3.0.0.0.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

This error is appearing as M/Docs II was installed on the computer, while being logged in as a user with a network profile. You need to use the M/Docs II Configuration Editor's Databases Migration Wizard to configure the installation:

1. Click on the Start button.
2. Click on All Programs.
3. Click on the Miller Davis Company folder.
4. Click on the MDocs II 3.0 folder.
5. Click on MDocsII Configuration Editor.
6. Click on Databases Migration Wizard.
7. Follow the onscreen prompts.
8. When the wizard is finished, close the M/Docs II Configuration Editor.
9. Open M/Docs II.

If you receive either of the following errors when trying to open M/Docs II, you will need to manually start/restart the SQL Server (SQLEXPRESS) service:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

OR

The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

The SQL Server (SQLEXPRESS) service will need to be started/restarted manually, here's how:

1. Click on the Start button.
2. Click on All Programs.
3. Click on the Microsoft SQL Server 2008 folder.
4. Click on Configuration Tools.
5. Click on SQL Configuration Manager, and a new window will open*.

   *If prompted with the User Account Control window,
   click Yes.

6. On the left side, click on SQL Server Services, and the right side will populate.
7. Right click on the SQL Server (SQLEXPRESS) service, and choose Start/Restart.
8. Once the service has restarted, under the State column, the SQL Server (SQLEXPRESS) service should be “Running.”
9. Close the SQL Server Configuration Manager.
10. Open M/Docs II.

Symptom:

When opening M/Docs II, the following error appears:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).

Possible causes include (click to show solution):

Symptom:

When opening M/Docs II, the following error appears:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).

Possible causes include (click to show solution):

If you receive the following error when trying to open M/Docs II, you will need to manually start the SQL Server (SQLEXPRESS) service.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server).

The SQL Server (SQLEXPRESS) service will need to be started manually, here's how:

1. Click on the Start button.
2. Click on All Programs.
3. Click on the Microsoft SQL Server 2008 folder.
4. Click on Configuration Tools.
5. Click on SQL Configuration Manager, and a new window will open*.

   *If prompted with the User Account Control window, click Yes.

6. On the left side, click on SQL Server Services, and the right side will populate.
7. Right click on the SQL Server (SQLEXPRESS) service, and choose Start.
8. Once the service has started, under the State column, the SQL Server (SQLEXPRESS) service should be “Running.”
9. Close the SQL Server Configuration Manager.
10. Open M/Docs II.

Cause: There is a minor corruption within the file structure.

Solution: Run the M/Docs II Cleanup tools.

1. Click the “Start” button.
2. Click on “All Programs.”
3. Click on the “Miller Davis Company” folder.
4. Click on the “M/Docs II 3.0” folder.
5. Click on “MDocs II Configuration Editor.”
6. Click the “Support Utilities” menu at the top of the window.
7. Click “Cleanup M/Docs II Settings”; click “OK” to confirm.
8. Click on the “Support Utilities” menu again.
9. Click on “Cleanup SQL Instances”; click “OK” to confirm.
10. Close the MDocs II Configuration Editor.

Cause: There is a corruption within the Microsoft SQL Server Data folder.

Solution: Run the M/Docs II Cleanup tools.

1. Click the “Start” button.
2. Click on “All Programs.”
3. Click on the “Miller Davis Company” folder.
4. Click on the “M/Docs II 3.0” folder.
5. Click on “MDocs II Configuration Editor.”
6. Click the “Support Utilities” menu at the top of the window.
7. Click “Cleanup M/Docs II Settings”; click “OK” to confirm.
8. Click on the “Support Utilities” menu again.
9. Click on “Cleanup SQL Instances”; click “OK” to confirm.
10. Close the MDocs II Configuration Editor.

Problem: You receive the following error upon opening M/Docs II:

Unhandled exception has occurred in your application…

Solution: There may be one or more updates for your software, therefore we recommend that you check for and apply any available updates:

1. Close any and all error messages.
2. Open M/Docs II again.*
   *If you receive this error again, please contact support@millerdavis.com.
3. Click on the Help menu near the top of the window.
4. Click on Check for Updates.
5. If updates are available, follow the onscreen directions. If there are no available updates, you will be notified.

   Important Note: There are two kinds of updates: Application updates and Database updates.

   Application Updates
   Application updates should be installed on each workstation running M/Docs II.
   When downloading the update file, be sure to save it to a local location.

   Database Updates
   When it comes to form database updates, the following holds true:
   *When downloading the update file, be sure to save it to a local location.

   1. If the computer is a stand-alone install, then the update will need to be downloaded to a local location on the workstation.
   2. If a computer is connected to a network database, the update will need to be downloaded and applied only on the computer acting as the M/Docs II server (make sure that file is downloaded to a local location on the server).

When trying to apply an update, you receive the following error:

Tables import failed. The import will be aborted and you should restore your Main database from the backup that was saved in the beginning of the process. The error was: Resetting the connection results in a different state than the initial login. The login fails. Login failed for user 'USERNAME'

A severe error occurred on the current command. The results, if any, should be disregarded.

Solution: Restart the computer and reapply the update. If the error appears again, please do the following:

Cleanup User SQL Instances

1. Click the Start button.
2. Click on All Programs.
3. Click on the Miller Davis Company folder.
4. Click on the M/Docs II 3.0 folder.
5. Click on M/Docs II Configuration Editor.
6. Click the Support Utilities menu at the top of the window.
7. Click on Cleanup SQL Instances, and then click OK to confirm.
8. Close the MDocs II Configuration Editor.

Manually Apply the Database Update

1. Open M/Docs II.
2. Click on the Tools menu.
3. Click on Apply Database Update.
4. Choose the proper database update. Note: The file extension will be .MDSU
5. When prompted to apply the update to your system, click Yes.
6. You will be prompted to make a backup of the current Main database, click Yes.
7. Choose a proper location for the backup, and then click Save.
8. You will be prompted to start the import process, click Yes.
9. When the import process is finished, click OK.
10. Click Finish.

When opening M/Docs II, receive the following error:

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

Cause: This issue is most likely due to a slow PC.

Solution: Change the database timeout using the M/Docs II Configuration Editor.

1. Click the Start button.
2. Click on All Programs.
3. Click on the Miller Davis Company folder.
4. Click on the M/Docs II 3.0 folder.
5. Click on MDocs II Configuration Editor.
6. Click on Configure Workstation.
7. Under the MDMain Database section, click on the Timeout button.
8. Increase the number of seconds for the program to timeout, and then click Accept.
9. Under the MDUser Database section, click on the Timeout button.
10. Increase the number of seconds for the program to timeout, and then click Accept.
11. Under the MDData Database section, click on the Timeout button.
12. Increase the number of seconds for the program to timeout, and then click Accept.
13. Save the changes to your configuration file by clicking the Save button then close the Configuration Editor.

When opening M/Docs II, the following error appears:

"Cannot open user default database. Login failed."

Solution: Depending on the type of install, either the database cache will need to be cleared, or you will need to correct permissions on the server.

Local Install

1. Click the Start button.
2. Click on All Programs.
3. Click on the Miller Davis Company folder.
4. Click on the M/Docs II 3.0 folder.
5. Click on MDocs II Configuration Editor.
6. Click the Support Utilities menu at the top of the window.
7. Click on Cleanup SQL Instances, and then click OK to confirm.
8. Close the MDocs II Configuration Editor.

Network Install

Contact your administrator to get permissions to the database.

M/Docs II automatically installs several components, including SQL Server Express 2008. Depending on your computer configuration, your PC may need to be restarted one or more times for the installation to finish. Therefore, please restart your PC, and run the M/Docs II installer again.

System Requirements: For a complete list of System Requirements, click on this link.

You will need to add the User as an admin to the local SQL Server. To do this, please follow the directions below:

1. Open My Computer.
2. Open the C drive.
3. Open the Program Files folder (Program Files (x86) on 64-bit computers).
4. Open the Miller Davis Company folder.
5. Open the MDocsII 3.0 folder
6. Double click on the file named AddSelfToSQLSysAdmin.cmd.
7. When the command window opens, press the Enter key on your keyboard.
8. When you see the message "'{USERNAME}' was successfully added to the 'sysadmin' role" press the Enter key again and the window will disappear.

Then try opening M/Docs II again. If you still run into the issue, let us know and we can schedule an appointment where we can connect to the computer to further troubleshoot.