Call Savance Workplace Call Us: (248) 478-2555

Support Suite

User Login



 

Main

Knowledgebase: Known Issues
SQL Server Not Found. Does Version 10.1.X Support Remote SQL Connections?
Posted by Robert Joseph on 11 January 2019 06:01 PM

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.