SQL Server Limited User


Overview

Beginning with Access It! Universal.NET version 5.5, a limited SQL account can be created within the Database Configuration Utility. This limited account will have the minimum permissions required to run Access It! Universal.NET

Implementation

  1. On the Server machine, browse to Start | Programs | Access It! Universal.NET | Utilities and open the Database Configuration Utility 
  2. Connect to the SQL Server using an account with administrative permissions to the AIUniversal database as well as SQL Server
  3. Once connected, select Create Limited User from the File menu
  4. Enter the new users username and password
  5. Click OK
  6. Close the Database Configuration Utility
  7. Reopen the Database Configuration Utility
  8. Connect to the SQL Server using the newly created limited SQL account
  9. Once connected, close the Database Configuration Utility
  10. If running, close Access It! Universal.NET 
  11. Browse to Start | Programs | Access It! Universal.NET | Utilities and open the Service Manager 
  12. Stop the Access It! Universal.NET service 
  13. Restart the Access It! Universal.NET service 

  • 630
  • 27-Feb-2019
  • 1217 Views