sql server create database error

Hi Krishna,

 

You can assign the sysadmin role to user. If you do not want to assign the user as sysadmin then you can assign the role of dbcreator because it has enough permission to create database.

 

EXEC master..sp_addsrvrolemember @loginame = N'Hello', @rolename = N'dbcreator'

GO 

Hello Krishna, What is error ? Can you show to me what is error message /Screen shot?

 

I have tried working fine. Check below screen shot also for your reference.