Resolving CREATE DATABASE Permission denied in database 'master' error on Vista and SQL Express

Have you encountered the error 'CREATE DATABASE Permission denied in database 'master'' even though you are logged into Windows Vista with administrator privileges.

Reason for the error : Windows Vista users that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically granted administrative privileges.

Resolution: Grant rights to the administrator. Follow these steps:

Step 1: Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.

Step 2: Click on 'Add New Administrator'.

Step 3: In the 'SQL Server User Provisioning on Vista' dialog box, look out for the 'Member of the SqlServer SysAdmin role ' in the 'Available Privileges' box. Transfer it to the 'Privileges that will be granted to' box. Click Ok.

Note: You will be able to see 'Add New Administrator' in the Configuration tool only if you have logged in as an administrator


About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook

57 comments:

Anonymous said...

Its working, thanks for the post.

Anonymous said...

Thanks! This really helped.

Anonymous said...

awesome. Thanks for the post!~

Syed Iqbal Simnani said...

Thanks a lot. I guessed that this was the problem, but did not know where to tell SQL server to use vitsa admin account. I wonder why Microsoft does not fix it.

Thanks once again.

Regards
Syed Iqbal Simnani

Anonymous said...

Thanks for the detailed post. Works great!

Anonymous said...

Thanks, helped a lot

sabna said...

thnak u very much..it worked...

Anonymous said...

Thanks a lot for your valuable steps...

Anonymous said...

Thanks.It helped me.

Anonymous said...

thank you so much it helped me a lot..

Ahmed Gamal said...

Thanks.

Anonymous said...

Thanks alot..its working..

Anonymous said...

awesome!!!
thanx a lot sir

Anonymous said...

I tried alot to solve.. but ur post helped me alot keep goingg

Chris said...

Thanks 4 this valuable info!

Anonymous said...

Thanks a lot.

Anonymous said...

Thanks its really helpful. Thanks for this post

zameer said...

Thanks for your help solved it with the

In the system.web section added

identity impersonate="true" userName="username here" password="pw here"

Thanks

Oscar said...

Thanks its working right now :)

cami said...

best post!
really really helped!
thanks

Nanda Kumar (ocs) said...

thank you..very much....


u help me a lot....

Ashu said...

Hi, All

I dont seen in Add New Administrator button.

so what should i do ??
I m using vindow's vista..
i did all these things written on this blog..
plz help me ..


Thanks

aditya said...

thanks, it really works!!

gv said...

nice

Anonymous said...

Wicked, Cheers

david said...

I installed the sql mangment studio 2008. the sqlservr.exe engine started as a network service. the studio starts as a user program, so it is not allowed to create a new database.
how to resolve this issue without the need to write a service that executes the sql management studio program.
David

Sujata said...

Thanks a lot..its working now..

Anonymous said...

Thanks,its working

Arunsai said...

'Member of the SqlServer SysAdmin role ' in the 'Available Privileges' box is missing

Anonymous said...

Hmmm - I don't have an "Add new administrator option".

I get two links

"Surface Area Configuration for Services and Connections"

and

"Surface area configuration for features"

Neither of these options contain the "Add new administrator" feature.

Anyone have any ideas?

The machine is a Windows Vista install, and I'm using SQL Express.

Anonymous said...

Just to add to that last post - I am logged in as an Administrator.

SQL server is a strange beast. You'd think that having installed it an an Administrator, I'd then be able to go in as that very same user and determine how I want to control access to it.

Fins said...

Very Good! Thanks.

Anonymous said...

thanks

Anonymous said...

Champion!!!!

Anonymous said...

thanks for help

Anonymous said...

thanks everything is now working...

YogY said...

Thanks very much ^________________^

Anonymous said...

Thank you so much. I have been trying to attach instnwnd.sql for over q week now, getting this message. So glad I finally ran accros your post.

vishnu said...

i use windows 7 .......... pls help me i have also this error.

link wheel said...

Hi,think you've made some truly interesting points. Not too many people would actually think about this the way you just did. I'm really impressed that there's so much about this subject that's been uncovered and you did it so well, with so much class. Good one you, man! Really great stuff here.

വള്ളുവനാട് കുഞ്ഞാലി said...
This comment has been removed by the author.
Grace said...

having the same problem using windows 7. pls help.

Ang maman said...

thanks. it's working for me

Anonymous said...

Thank you for your post sir. It really helped me. Two thumbs UP !!

free auto insurance quotes said...

I was facing the same problem and was looking for a permanent solution.But i couldn't fond one.After reaching here.I found the solution.Now everything is just perfect.And my database is working fine.

Anonymous said...

Good work!Thanks a lot.Its working now

Anonymous said...

thanks boss

mashie said...

thanks for the information ;) for almost a semester i can't use my sql server thanks for the help! GOdbless!;)

Lewis said...

This makes me want to cry. it still isn't working

link wheel said...

SO HERE ARE MY QUESTIONS :

1. Am I allowed to run my program using user "TestUser" since SQL is installed using "Glen" windows user?

2. Do I need to add access rights to "TestUser" to allow the user to have CREATE rights? (Note : for security reason, I can add other access rights except Administrator)

ams said...

Thanks a lot .its working

ams said...

When connceting to sql server 2005 a network-related error has occuring .how to solve this

Marc said...

Thank you very much! Workly on SQL Server 2008 too!

Rashad Yakub said...

Thank you so much, 100% helpful.

Rich said...

I'm using SQL 2014 and I still needed to go into my SQL 2005 and modify this setting...Thanks!

Cesar Mata said...

Thank you very much! Very very helpful!

chathura ravin said...

greate,,,thanx