support Posted January 28, 2021 Posted January 28, 2021 Recently we have seen a increase in the amount of Support calls, surrounding how to install Passwordstate in Azure. The below is a guide on how to set this up. There are a couple of different answers to this, depending on how you want to host Passwordstate. The installer creates a website for you, which must be hosted on a Windows machine, and this website is then connected to a database. If you already have a full Windows VM in Azure, it is possible to install the Passwordstate Website and SQL (Express or above) together on this machine. If you are hoping for this type of set up, then the https://www.clickstudios.com.au/downloads/version9/Installation_Instructions.pdf don’t change given this is really no different than installing it locally. If you don’t want to run up a full virtual machine, we also support making use of the Azure SQL servers. This would be applicable if you intended to host your Passwordstate website locally in your network, and have it communicating to an Azure database. To do this, you need to first create the database in Azure, create an account with at least db_owner rights to that database, and then during your Passwordstate initial configuration, select the “Connect to Blank database” option. This can be found on Page 14 of the https://www.clickstudios.com.au/downloads/version9/Installation_Instructions.pdf. Basically you will select Microsoft Azure, and enter in the details of your Azure database server. One thing our install instructions don’t mention, is how to create a SQL user and apply permissions to an Azure database. I’ve pasted in some commands below on how to do this manually using SQL Management Studio Tools, and this assumes you have already created a blank database in Azure called “Passwordstate”. This is what we used to set up our Azure environment, but you may have alternative methods: Connect to you Azure database server with SQL Management Studio Tools. Azure does not allow for the USE statement, so we need to right Click Master Database and select New Query. Execute the following script, but ensure you change the password to something personal instead of Welcome12345: CREATE LOGIN passwordstate_user WITH password='Welcome12345' GO CREATE USER passwordstate_user FOR LOGIN passwordstate_user WITH DEFAULT_SCHEMA=[dbo] GO Next right click your Passwordstate database, select New Query and run this script: CREATE USER passwordstate_user FOR LOGIN passwordstate_user WITH DEFAULT_SCHEMA=[dbo] GO EXEC sp_addrolemember 'db_owner', 'passwordstate_user'; GO You should now be able to use the connect to Blank database option during your initial Passwordstate setup.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now