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
- 86 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 111 Rules
- 282 Administration
- 216 Portal
- 500 General Q & A
- 718 Forms
- 353 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 189 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 71 Repository
- 233 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 27 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions