sql permission issue
Comments
-
I am trying to connect sql express but I am getting the following error and I am not sure which account we need to use
-
Check that the SQL account used for the database has all the correct permissions. Have a look at this page: https://documentation.decisions.com/docs/en/sql-server-database-permissions. I created a separate SQL user and gave it the reduced permissions as listed on that page. I am using SQL Server so hopefully that applies to SQL Express, too.
-
Hey
The error suggests that the account used for installation purposes doesnt have the required permissions.
Certain permissions need to be assigned to the user so that the user would be able to connect to the database successfully. These permissions are listed at our documentation [url=https://documentation.decisions.com/docs/en/sql-server-database-permissions]SQL Server Database Permissions[/url]. Please refer to this documentation and let us know at support@decisions.com if you come across any difficulties.Thanks
-
[color=rgb(26, 26, 27)][font=\" noto=\"\" sans\
-
For most purposes we usually use an account with system admin privileges on the SQL Server. Also to note: to be able to use standard authentication while setting up your database in the Decisions installer, you will need to modify your SQL Server to use mixed auth types.
Howdy, Stranger!
Categories
- 4.2K All Categories
- 67 General
- 11 Training
- 202 Installation / Setup
- 1.1K Flows
- 106 Rules
- 262 Administration
- 212 Portal
- 490 General Q & A
- 695 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 179 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 78 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 83 Lunch And Learn Questions