I am using a new virtual server on premise, SQL SERVER 2019.
I was able to install and connect to Sql Server Mgmt Studio with Windows Auth.
I have gone through the simple steps to create a New Database. R click on Databases and choose New Database.
Every time, I get that I do not have the permission to create in master. Then I tried model. Still no permissions.
I've been through a number of possible solutions by searching online.
Can anyone tell me what I am doing wrong?
Thanks.
I was able to install and connect to Sql Server Mgmt Studio with Windows Auth.
I have gone through the simple steps to create a New Database. R click on Databases and choose New Database.
Every time, I get that I do not have the permission to create in master. Then I tried model. Still no permissions.
I've been through a number of possible solutions by searching online.
Can anyone tell me what I am doing wrong?
Thanks.