Using an existing SQL Instance when installing Acctivate.

If you've already got your own SQL instance and want Acctivate to use it, take these steps when installing.

By default, the Acctivate Installer will create the “ACCTIVATE” named instance of SQL Server 2019 Express unless a previously installed SQL Server instance exists that is specifically named ACCTIVATE.

Acctivate can be installed with an existing SQL Server instance that is NOT named ACCTIVATE. Use the procedure below to install Acctivate to utilize your existing SQL Server instance.

  1. Download Acctivate (Full Install) and save the installation file.
  2. Locate the Acctivate installation file and Rename the file to setup.exe (NOTE: Simply rename to “setup” if the file extension (i.e. exe) is not visible)
  3. Open a new Command Prompt window from the Start Menu
  4. Change Directory (CD) to the location of the Acctivate installer file
    • The default Downloads folder is below the User directory (e.g. C:\Users\YourName\Downloads).  The CD Downloads command will likely switch to the proper directory.

5. Execute the Acctivate installer using one of the commands below.

Command Options

NOTE: If your instance was created with the default name of MSSQLSERVER, you will probably need to use the path of just "SERVERNAME" rather than "SERVERNAME\INSTANCE".

Option A: Connect with SQL Authentication (PREFERRED method for Acctivate)

Copy/Paste the following into the Command Prompt:

(Acctivate versions prior to 11.1):
setup /sqlserver:SERVERNAME\INSTANCE /sqluid:sa /sqlpwd:password

(Acctivate versions 11.1 or later):
setup /sqlserver=SERVERNAME\INSTANCE /sqluid:sa /sqlpwd:password
  • Replace SERVERNAME\INSTANCE with the full SQL Server instance name
  • Replace sa with the SQL Login that is a member of the sysadmin SQL Server role
    • Please Note: Unless modified during install, this is SA
  • Replace password with the password for that SQL Login
  • Press ENTER to start the installation

Option B: Connect with Windows Authentication

Copy/Paste the following into the Command Prompt:

(Acctivate versions prior to 11.1):

setup /sqlserver:SERVERNAME\INSTANCE /sqltrusted

(Acctivate versions 11.1 or later):

setup /sqlserver=SERVERNAME\INSTANCE /sqltrusted
  • Replace SERVERNAME\INSTANCE with the full SQL Server instance name
  • Press ENTER to start the installation

Demo Company

You can also install Acctivate without loading the Demo company database with the /nodemo switch. Combining these into one script would be something like:

setup /sqlserver:SERVERNAME\INSTANCE /sqluid:sa /sqlpwd:password /nodemo

Alternatively, the following command would utilize Windows Authentication:

setup /sqlserver:SERVERNAME\INSTANCE /sqltrusted /nodemo

 

In Acctivate version 11.1+, replace the ":" with an "=". e.g.:
... /sqlserver:SERVERNAME\INSTANCE ...
... /sqlserver=SERVERNAME\INSTANCE ...