Jump to content
Sign in to follow this  
support

Passwordstate Required SQL Permissions

Recommended Posts

In order for Passwordstate to function with any of the supported versions of Microsoft's SQL Server, your SQL Server must be configured with Mixed Mode Authentication - Passwordstate relies on SQL Accounts for database connectivity, and Windows accounts cannot be used for this purpose.

During the initial setup of Passwordstate when you are asked to specify a SQL Account to create the database, the SQL Account must have the following privileges:

 

At a minimum the SQL Account must have the "dbcreator" and "securityadmin" SQL Server roles - dbcreator to create the database/tables, and securityadmin to create an SQL Account called 'passwordstate_user' which is used so the Passwordstate web site can connect to the SQL Server. The sa account has these privileges, although some DBA's do not like to use this account due to its elevated privileges.

 

Please note the SQL account you specify during the initial install of Passwordstate is not recorded, or used again anywhere in your Passwordstate instance.  It is a once off request to set up Passwordstate, and is never used again.

 

Regards

Click Studios

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...