April 15, 2008

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


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter


About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

 
  Feedback:

comments

54 Responses to "Resolving CREATE DATABASE Permission denied in database 'master' error on Vista and SQL Express"
  1. Anonymous said...
    June 19, 2008 at 1:43 AM

    Its working, thanks for the post.

  2. Anonymous said...
    June 29, 2008 at 2:56 AM

    Thanks! This really helped.

  3. Anonymous said...
    August 24, 2008 at 5:13 PM

    awesome. Thanks for the post!~

  4. Syed Iqbal Simnani said...
    October 3, 2008 at 9:37 AM

    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

  5. Anonymous said...
    October 10, 2008 at 6:48 AM

    Thanks for the detailed post. Works great!

  6. Anonymous said...
    November 16, 2008 at 10:15 PM

    Thanks, helped a lot

  7. sabna said...
    January 21, 2009 at 4:53 AM

    thnak u very much..it worked...

  8. Anonymous said...
    January 22, 2009 at 7:00 AM

    Thanks a lot for your valuable steps...

  9. Anonymous said...
    March 10, 2009 at 6:28 PM

    Thanks.It helped me.

  10. Anonymous said...
    March 12, 2009 at 12:41 PM

    thank you so much it helped me a lot..

  11. Ahmed Gamal said...
    March 21, 2009 at 3:42 AM

    Thanks.

  12. Anonymous said...
    May 23, 2009 at 12:37 PM

    Thanks alot..its working..

  13. Anonymous said...
    May 24, 2009 at 12:06 AM

    awesome!!!
    thanx a lot sir

  14. Anonymous said...
    May 28, 2009 at 8:06 PM

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

  15. Chris said...
    May 31, 2009 at 1:09 PM

    Thanks 4 this valuable info!

  16. Anonymous said...
    July 12, 2009 at 10:06 PM

    Thanks a lot.

  17. Anonymous said...
    July 23, 2009 at 12:08 PM

    Thanks its really helpful. Thanks for this post

  18. zameer said...
    August 25, 2009 at 3:16 AM

    Thanks for your help solved it with the

    In the system.web section added

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

    Thanks

  19. Oscar said...
    September 10, 2009 at 7:41 PM

    Thanks its working right now :)

  20. cami said...
    September 17, 2009 at 6:10 AM

    best post!
    really really helped!
    thanks

  21. Nanda Kumar (ocs) said...
    September 29, 2009 at 12:04 AM

    thank you..very much....


    u help me a lot....

  22. Ashu said...
    January 9, 2010 at 3:36 AM

    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

  23. aditya said...
    January 31, 2010 at 11:52 PM

    thanks, it really works!!

  24. gv said...
    February 5, 2010 at 9:24 AM

    nice

  25. Anonymous said...
    February 11, 2010 at 8:09 AM

    Wicked, Cheers

  26. david said...
    April 12, 2010 at 2:47 AM

    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

  27. Sujata said...
    April 15, 2010 at 11:24 AM

    Thanks a lot..its working now..

  28. Anonymous said...
    June 23, 2010 at 7:09 PM

    Thanks,its working

  29. Arunsai said...
    June 28, 2010 at 1:07 AM

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

  30. Anonymous said...
    July 9, 2010 at 5:52 AM

    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.

  31. Anonymous said...
    July 9, 2010 at 5:57 AM

    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.

  32. Fins said...
    August 26, 2010 at 11:40 AM

    Very Good! Thanks.

  33. Anonymous said...
    October 6, 2010 at 11:13 AM

    thanks

  34. Anonymous said...
    November 21, 2010 at 1:25 AM

    Champion!!!!

  35. Anonymous said...
    January 7, 2011 at 9:31 AM

    thanks for help

  36. Anonymous said...
    January 11, 2011 at 9:15 AM

    thanks everything is now working...

  37. YogY said...
    January 21, 2011 at 8:46 PM

    Thanks very much ^________________^

  38. Anonymous said...
    February 6, 2011 at 8:10 PM

    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.

  39. vishnu said...
    March 11, 2011 at 6:35 PM

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

  40. link wheel said...
    March 14, 2011 at 12:36 AM

    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.

  41. വള്ളുവനാട് കുഞ്ഞാലി said...
    March 23, 2011 at 5:55 AM
    This comment has been removed by the author.
  42. Grace said...
    May 29, 2011 at 11:58 AM

    having the same problem using windows 7. pls help.

  43. Ang maman said...
    June 7, 2011 at 9:42 PM

    thanks. it's working for me

  44. Anonymous said...
    July 21, 2011 at 4:51 AM

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

  45. free auto insurance quotes said...
    July 22, 2011 at 9:15 PM

    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.

  46. Anonymous said...
    August 17, 2011 at 10:48 AM

    Good work!Thanks a lot.Its working now

  47. Anonymous said...
    November 8, 2011 at 7:20 AM

    thanks boss

  48. mashie said...
    November 20, 2011 at 10:20 PM

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

  49. Lewis said...
    November 28, 2011 at 4:47 PM

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

  50. link wheel said...
    February 13, 2012 at 5:31 PM

    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)

  51. ams said...
    July 25, 2012 at 9:51 AM

    Thanks a lot .its working

  52. ams said...
    July 25, 2012 at 9:54 AM

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

  53. Marc said...
    October 12, 2013 at 4:22 PM

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

  54. Rashad Yakub said...
    September 29, 2014 at 11:55 PM

    Thank you so much, 100% helpful.

 

Copyright © 2009-2014 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions