How to use the Keystroke Sql Login Creator?

Some Keystroke products might require a direct connection to the Act! database using SQL. To allow for this, the Keystroke SQL Login Creator app can be used to create a custom user account, which can be used by the products to access the database. In order to set it up, pleaes follow the steps below:

  1. Log in to the server where the Act! database is located.
  2. Download the Keystroke Sql Login Creator from here
  3. Run the program and press the Find Servers button as shown below:



  4.  Once the search is completed, select your server from the dropdown:


  5.  After selecting your server, click the Connect to Server button.  

  6. Finally,  in Step 4, enter a secure password that will be used for connecting to SQL, and press the Create Login button.
    Note: that if there will be remote database users, all users must enter the same password or else there will be connection issues after synchronizing. If you are running this utility on a remote database, please consult with the Act! Administrator and ensure you have the correct Sql password to enter in this step.



  7. Once the user account is created, you may now close the application and load the Keystroke app or addon that requires Sql access.