I installed FlexiCapture 12 Distributed edition using SQL Server Express installed on the same server.
I configured the database server using the SA account.
I would like to use a different account to connect to the database.
What permissions are required?
I tried giving the new user db_owner on the flexicapture database and the master database, and it wasn't able to connect.
Comments
2 comments
Hello,
Please make sure that you configured the database with according the system administrator guide p.26-27 instructions. Note that user account that you want to connect to the database has DBA permissions for Microsoft SQL Server. If you encounter authentication problems when testing the connection, check to make sure that Mixed Authentication Mode is enabled for Microsoft SQL Server ("SQL Server and Windows authentication").
I realized after I wrote this post that the process of creating the db for the first time actually creates another user account to connect to the db so even using the sa account is only temporary during the initial creation of the database.
Please sign in to leave a comment.