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.4K All Categories
- 78 General
- 13 Training
- 209 Installation / Setup
- 1.1K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 497 General Q & A
- 709 Forms
- 345 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 186 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 229 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions