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
- 2.1K All Categories
- 18 General
- 155 Installation / Setup
- 991 Flows
- 86 Rules
- 203 Administration
- 204 Portal
- 433 General Q & A
- 600 Forms
- 282 Reports
- 3 Designer Extensions
- 38 Example Flows
- 32 CSS Examples
- 1 Diagram Tile
- 5 Javascript Controls
- 139 Pages
- 1 Process Mining
- New Features
- 150 Datastructures
- 50 Repository
- 169 Integrations
- 25 Multi-Tenant
- 21 SDK
- 40 Modules
- 38 Settings
- 20 Active Directory
- 12 Version 7
- 34 Version 8