1. Home
  2. Knowledge Base
  3. On-premise/Customer-Hosted Server
  4. SQL
  5. SQL Server Not Found. Does Version 10.1.X Support Remote SQL Connections?

SQL Server Not Found. Does Version 10.1.X Support Remote SQL Connections?

Yes. It is a supported connection. This edge case article makes a few assumptions about your understanding of the current EIOBoard Server configuration. You will need to know the machine hosting the SQL Server, a SQL user account with permissions over the EIOBoard database. The upgrade process from early version 9 does not follow the standard upgrade installation process. This requires an advanced mode installation.

  1. Uninstall the EIOBoard Server from Programs and Features
  2. If the uninstall fails, install and run the Windows Cleanup Utility to remove the installation references to EIOBoard Server.
    http://eioboard.com/downloads/utils/WindowsInstallerCleanupUtility.exe
  3. Stop the EIOBoard Service and remove theĀ registry entry underĀ “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services”
  4. Under Program Files (x86), rename the installation folderĀ  ‘Savance’ to ‘V9_Savance’
  5. Delete the EIOBoard Website from IIS Manager
  6. https://support.savance.com/index.php?/eioboard/Knowledgebase/Article/View/664/0/run-v10-on-premise-installer-in-advanced-mode
  7. When prompted, ‘Skip the Database’
  8. Select your option for the EIOBoard website
  9. Upon successfully installing the EIOBoard Server, move forward with upgrading the database. Note: The database must be hosted on SQL Server 2012 R2 or newer.
    https://support.savance.com/index.php?/eioboard/Knowledgebase/Article/View/17/0/what-are-the-system-requirements-and-server-specifications-for-the-eioboard-server
  10. https://support.savance.com/index.php?/eioboard/Knowledgebase/Article/View/443/0/manually-upgrade-the-database
  11. Connect to the Database from Management Studio to execute these upgrade scripts sequential on the SolutionSavant database or your renamed EIOBoard database
    https://www.eioboard.com/downloads/releases/10.0.33/ebcustomerdatabaseupgrade10033.zip
  12. Execute the upgrade script related to the installer.
    https://www.eioboard.com/downloads/releases/10.0.59/ebcustomerdatabaseupgrade10059.zip
  13. Verify the web.config file to include the proper SQL Connection information around lineĀ 22
  14. Verify the Database references the new EIOBoard Server Settings
  15. Verify your login credentials validate on the web application

Delete theĀ ‘V9_Savance’ folder once the version 10 installation is operational.
This completes the advanced mode upgrade process with a remote SQL server instance.

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support