sql server create database error

Question

i have install SQL SERVER 2008 but when open sql and write query when selected in database section master and write query

suppose i want to create database

create database Hello(my database name)

when i executed i have error master database not create database why plz help...:)

Dazy Parker · Answer

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

Ranjit Powar · Answer

Share error message

Raja T · Answer

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.