IPGRAY : Sql Server - How to fix CREATE DATABASE permission denied in database 'master'

IPGRAY : Sql Server - How to fix CREATE DATABASE permission denied in database 'master'

This video shows how to fix CREATE DATABASE permission denied in database 'master' error message

1. You get this error message when you try to create a data base with the user account you created
2. You will not get this error if you login as windows authentiation user
3. The goal of this video is to provide full access to the user you create in the previous video
IPGRAY : Sql Server - How to create user account in Sql Server Express 2017

4. Login to sql server using Sql Server Management Studio
5. Login as windows authentication
6. close Sql Server Management Studio
7. Login to sql server using Sql Server Management Studio
8. Login as sql server authentication
8. create data base

follow the instructions on the video

thanks for watching
follow more IPGRAY videos on youtube
please subscribe

[ASHISHYadav-fxqg]

it says grantor does not have grant permission

[AmanKumar-zihx]

Thank you. Buddy!!!! I watched many videos and other help tips but this only worked for me.

[BBOYLEENON]

Thank you very much bro, you helped me a lot.

[ashokreddybasham]

"CREATE DATABASE statement not allowed within the multi-statement transaction".
I am facing the above issue while I try to create a Database in SSMS with SQL Server Credentials using Python script.
Please help how to get out of this error.

[ASHISHYadav-fxqg]

i have sql server 2005 and in the properties->permission there is no user of name 'admin-user'

[jasongrant]

it said i grantor does not have grant permission