I've recently setup a google cloud server for the first time and I installed the asp.net framework which is marketed as "Windows dev stack featuring IIS, SQL Express and ASP.NET". I'm familiar with SQL Server, c# asp.net and would like my first project done with these technologies for simplicity.
I manually installed sql server data tools, I can jump on the RDP and log into the localhost sql server via SSMS but my windows account does not have permissions to add a new database or create a user who does have permissions. I can see the sa user in there but do not know the password.
How can I add a sql server database into the local sql server express?