Create a user in MSSQL
Log into the SQL database for the server you require an account for i.e. dev/rep/prod.
In the object explorer on the left hand side, expand the security option and then the Logins option.
Look to see if the account already exists, as it may be just a permissions issue, or they may just require a password reset.
If the user does not exist, right click the Logins option and click New Login.
Fill in all the details in the pop up that opens, the Login name, will be at the council's discretion, but is usually just the workers system user ID.
Make sure to click SQL authentication instead of windows and set a strong password.
For the rest of the details, bring up a user with the same role as the one you're creating and assign all the permissions as appropriate.
Click Apply and then close the pop up and the user should be able to log in as expected from now on.
📌Note: Normally we don't administer SQL accounts for users, however in some extreme circumstances, such as when a council has no users with admin rights available, we can do this for you. If you need this, please raise a new case online and reference the title of this article.
Disable a user in MSSQL
You might need to disable a user for various reasons, like security concerns or administrative purposes. Follow these steps to disable a user:
Connect to the SQL Server.
Open SQL Server Management Studio (SSMS) and connect to the appropriate SQL Server instance.
Go to Security.
In Object Explorer, expand the Security folder.
Expand the Logins folder to locate the user you want to disable.
Right-click on the user, select Properties, go to the Status page, and set the Login option to Disabled.
Click OK to save the changes.