Installation
https://www.microsoft.com/en-gb/sql-server/sql-server-downloads Note that admin rights are required for installation.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Admin rights are also required for installation.
Open SQL Server Management Tool as admin. On the left, open the top level node, then right-click on Databases, and create a new database. Give the DB a name.
Now, we need to give non-admin users permission to access the database. This includes your own non-admin account if applicable, as failing to give your non-admin account permissions means that you can't access the DB through Grasshopper for example.
Open up the new node for your DB. Navigate to 'users' and right-click to create a new user.
Under "User type", select Windows user.
You then need to find your account. Select the three dots to the right of the "User name" field. Then, click the "Locations" button. Then, under "Entire Directory", select burohappold.com and press OK. Then, type your name under "Enter the object name to select", and click "Check Names". Press OK on the next two windows.
Confirm that this has worked by checking that this user has been added to the 'Users' folder.
Finally, we must then assign permissions to this user. Follow this StackOverflow answer: https://stackoverflow.com/a/51847826/5728488
You should now be able to connect to the DB you created above. Replace DBTest with the name of the database you created.
