Engineerica Knowledge Base
            Knowledge Base Engineerica Software KB AccuTrack-AccuSQL FAQ Admin Guide

            AccuSQL: How to Change the Database Location

            Method 1: Sign-in to the AccuSQL client as a system administrator and change the database location


            Step 1:      From right side of the System Administration screen, Click on Database


            Step 2:      Click on Database Location


            Step 3:      Select the SQL Server radio button and Click Next


            Step 4:      Enter the SQL server connection info section. 

            Fill out the server, Authentication mode, UserName, and Password fields, then click Test Connection to verify the test connection is successful. If it is successful, you will be able to select the Database from the drop-down menu.

            Step 5:      Click Save


            Step 6:      You will receive this prompt, Click OK

             
            Step 7: Exit out of AccuSQL and relaunch the application. You should now be connected to the new database location.


            Method 2: Change Database location using setdatapath.exe

            This method is very useful if the database for AccuSQL is ever migrated e.i. Server upgrade or if the Active Directory account used for access to the SQL database is ever changed e.i. password update
            Repeat Method 2 on each computer that the AccuSQL client is installed on

            Step 1:      In File Explorer, open the Program folder for AccuSQL. Go to C:\Program Files (x86) and open the AccuSQL folder.


            Step 2:      Locate and Open the accudata folder


            Step 3:     Copy the accudata file path and temporarily paste it on Notepad
              


            Step 3:      Go back to the AccuSQL program folder. Locate and Run setdatapath.exe
             

            Step 4:      Select SQL Server and Click Next


            Step 5:     Copy the file path location from Notepad and Paste it in Application Shared path
                  

            Step 6:      Fill out the SQL server connection information and Select the database
                  

            Step 7:      Click Save


            Step 8:      Click OK
                   

            Step 9:      Launch AccuSQL. You should now be connected to the new database location.

            Updated: 28 Jan 2019 05:51 AM
            Helpful?  
            Help us to make this article better
            0 0