Scenario - While working on a CI/CD for SQL database, I did not have a local database. So I went ahead to get the help from I.T. team because I did not have the rights to install any exe on my laptop.
Post installation of the SQL Server Express server, I tried to create database and it was throwing below error.
CREATE DATABASE permission denied in database 'master'.
Solution- I added my id as sysadmin by going to database => Security => New Login => and Then Assigned all the roles as it was an experimental project, but sysadmin and DB creator would also have worked in this case.
