Home >> Forms Software >> Support >> Troubleshooting

Troubleshooting Error Messages

If you’ve received any of the error messages below, click on the error message to learn its cause and solution.

  1. User with Network Profile (UNC Share).

    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.
  2. SQL Error 0 - Named Pipes Provider, error: 0

    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.
  3. SQL Network Interfaces, error: 26 (LOCAL INSTALL)

    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):

    SQL Server Express 2008 is not installed on the user PC.

    The M/Docs II installer automatically installs the SQL Server Express 2008 component; however a PC restart may be required for it to finish. Therefore, please restart your PC, disable your antivirus and run the M/Docs II installer again. Please make sure that you are logged into the computer as user with administrative rights.

    The SQL Server EXPRESS service needs to be started manually on the user PC.
    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 the SQL Server Configuration Manager.*.
      *If prompted with the User Account Control window, click Yes.
    6. A new window will open with 2 panes; on the left-hand side, click on SQL Server Services.
    7. On the right-hand side, look to see if the SQL Server (SQLEXPRESS) is Running or Stopped.
      • If it is Running, right-click on SQL Server (SQLEXPRESS), and choose Restart.
      • If it is Stopped, then right-click on SQL Server (SQLEXPRESS) and choose Start.
    8. Close the SQL Server Configuration Manager.
    9. Open M/Docs II.
    A version other than SQL Server Express 2008 is installed.

    A version other than SQL Server Express 2008 is installed: If this is the case, then verify whether or not any other programs running on the computer utilize this software.

    If so, then check with the vendor(s) to see if their software is compatible with SQL Server Express 2008. If they are compatible with SQL Server Express 2008, then uninstall all related SQL components (be sure to delete the installation directory after uninstalling). Afterwards, restart the PC, disable your antivirus and reinstall M/Docs II. Please make sure that you are logged into the computer as user with administrative rights.

    If there are no other programs utilizing SQL Server, then uninstall all related SQL components (be sure to delete the installation directory after uninstalling). Afterwards, restart the PC, disable your antivirus and reinstall M/Docs II. Please make sure that you are logged into the computer as user with administrative rights.

  4. SQL Network Interfaces, error: 26 (NETWORK INSTALL)

    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):

    SQL Server Express 2008 is not installed on the user PC and/or the PC acting as the M/Docs II server
    The M/Docs II installer automatically installs the SQL Server Express 2008 component; however a PC restart may be required for it to finish. Therefore, please restart your PC, disable your antivirus and run the M/Docs II installer again. Please make sure that you are logged into the computer as user with administrative rights.
    The SQL Server EXPRESS service needs to be started manually on the user PC

    Check to see if the SQL Server (EXPRESS) service is running on the user PC:

    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 the SQL Server Configuration Manager*.
      *If prompted with the User Account Control window,
      click Yes.
    6. A new window will open with 2 panes; on the left-hand side, click on SQL Server Services.
    7. On the right-hand side, look to see if the SQL Server (SQLEXPRESS) is Running or Stopped.
      • If it is Running, right-click on SQL Server (SQLEXPRESS), and choose Restart.
      • If it is Stopped, then right-click on SQL Server (SQLEXPRESS) and choose Start.
    8. Close the SQL Server Configuration Manager.
    9. Open M/Docs II.
    The SQL Server EXPRESS and/or SQL Server Browser service(s) need to be started manually on the PC acting as the M/Docs II server
    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 the SQL Server Configuration Manager*.
      *If prompted with the User Account Control window, click Yes.
    6. A new window will open with 2 panes; on the left-hand side, click on SQL Server Services.
    7. On the right-hand side, look to see if the SQL Server (SQLEXPRESS) is Running or Stopped.
      • If it is Running, right-click on SQL Server (SQLEXPRESS), and choose Restart.
      • If it is Stopped, then right-click on SQL Server (SQLEXPRESS) and choose Start.
    8. On the right-hand side, look to see if the SQL Server Browser is Running or Stopped.
      • If it is Running, right-click on SQL Server Browser, and choose Restart.
      • If it is Stopped, then right-click on SQL Server Browser and choose Start.
    9. Close the SQL Server Configuration Manager.
    10. Open M/Docs II.
    The firewall on the PC acting as the M/Docs II server is not configured to allow for SQL Server traffic

    The firewall should allow SQL Server traffic, which is usually on port 1433 and the SQL Browser on Port 1434, unless the administrator changed these. General instructions for configuring the windows firewall to allow SQL Server traffic can be found at http://msdn.microsoft.com/en-us/library/ms175043.aspx. For other firewalls, please check the firewall provider's instructions.

    A version other than SQL Server Express 2008 is installed

    A version other than SQL Server Express 2008 is installed: If this is the case, then please verify whether or not any other programs running on the computer utilize this software.

    If so, then check with the vendor(s) to see if their software is compatible with SQL Server Express 2008. If they are compatible with SQL Server Express 2008, then uninstall all related SQL components (be sure to delete the installation directory after uninstalling). Afterwards, restart the PC, disable your antivirus and reinstall M/Docs II. Please make sure that you are logged into the computer as user with administrative rights.

    If there are no other programs utilizing SQL Server, then uninstall all related SQL components (be sure to delete the installation directory after uninstalling). Afterwards, restart the PC, disable your antivirus and reinstall M/Docs II. Please make sure that you are logged into the computer as user with administrative rights.

  5. SQL Error 40 - Shared Memory Provider Error: 40

    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.
  6. Program Not Responding.

    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.
  7. Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

    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.
  8. Unhandled Exception Error upon Opening M/Docs II

    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).
  9. Tables import failed.

    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.
  10. Timeout Expired.

    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.
  11. Cannot open user default database. Login failed.

    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.

  12. The M/Docs II installation unexpectedly fails.

    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.

  13. Login failed for User {USERNAME}.

    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.

M/Docs II helps you complete multiple legal forms quickly and easily with authority.

Click-here to start today!


CONTACT US