Step by step video: \\rb-deploy1\deployment$\Software\Microsoft\SQL\SQLExpressTutorial.mp4
1. \\rb-deploy1\deployment$\Software\Microsoft\SQL\SQLExpress2019 > Select SQLEXPR_x64.exe and Run as Administrator
2. Select "OK"
3. Allow the install to run
4. "Open File - Security Warning" will come up several times (Click Run)
5. Allow the first part of the download to complete
6. SQL Server Installation Center will pop up > Select "New SQL Server stand-alone installation or add features to an existing installation"
7. Select "Run"
8. Select "I accept the license term and Privacy Statement" and hit "Next"
9. Select "Next" (it is normal for Windows Firewall to have a warning)
10. Keep all information as default
11. Make sure the named Instance is set to "SQLExpress"
12. Set Server Configuration as default
13. Select Mixed Mode and generate a 15-20 passcode; username will be sa (save passcode to Thycotic)
*View Thycotic Tab - SQL E
14. Completed
15. Open SSMS and authenticate using SQL Server Authentication
16. Open drop down for "Security" > Right Click Login > Create New Login
17. Select "Search" next to login name
18. Change Location to "titan.local" > Enter the object name to select (Example: vivian admin) > Hit "OK"
19. To connect to the database, go to SSMS and right click > Run as different user > Sign in with admin credentials
