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
at

56 comments:

  1. AnonymousJune 19, 2008 at 1:43 AM

    Its working, thanks for the post.

    ReplyDelete
  2. AnonymousJune 29, 2008 at 2:56 AM

    Thanks! This really helped.

    ReplyDelete
  3. AnonymousAugust 24, 2008 at 5:13 PM

    awesome. Thanks for the post!~

    ReplyDelete
  4. AnonymousOctober 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

    ReplyDelete
  5. AnonymousOctober 10, 2008 at 6:48 AM

    Thanks for the detailed post. Works great!

    ReplyDelete
  6. AnonymousNovember 16, 2008 at 10:15 PM

    Thanks, helped a lot

    ReplyDelete
  7. UnknownJanuary 21, 2009 at 4:53 AM

    thnak u very much..it worked...

    ReplyDelete
  8. AnonymousJanuary 22, 2009 at 7:00 AM

    Thanks a lot for your valuable steps...

    ReplyDelete
  9. AnonymousMarch 10, 2009 at 6:28 PM

    Thanks.It helped me.

    ReplyDelete
  10. AnonymousMarch 12, 2009 at 12:41 PM

    thank you so much it helped me a lot..

    ReplyDelete
  11. Ahmed GamalMarch 21, 2009 at 3:42 AM

    Thanks.

    ReplyDelete
  12. AnonymousMay 23, 2009 at 12:37 PM

    Thanks alot..its working..

    ReplyDelete
  13. AnonymousMay 24, 2009 at 12:06 AM

    awesome!!!
    thanx a lot sir

    ReplyDelete
  14. AnonymousMay 28, 2009 at 8:06 PM

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

    ReplyDelete
  15. UnknownMay 31, 2009 at 1:09 PM

    Thanks 4 this valuable info!

    ReplyDelete
  16. AnonymousJuly 23, 2009 at 12:08 PM

    Thanks its really helpful. Thanks for this post

    ReplyDelete
  17. zameerAugust 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

    ReplyDelete
  18. Oscar PadrónSeptember 10, 2009 at 7:41 PM

    Thanks its working right now :)

    ReplyDelete
  19. camiSeptember 17, 2009 at 6:10 AM

    best post!
    really really helped!
    thanks

    ReplyDelete
  20. Nanda Kumar (ocs)September 29, 2009 at 12:04 AM

    thank you..very much....


    u help me a lot....

    ReplyDelete
  21. WebExpertt.ComJanuary 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

    ReplyDelete
  22. UnknownJanuary 31, 2010 at 11:52 PM

    thanks, it really works!!

    ReplyDelete
  23. AnonymousFebruary 5, 2010 at 9:24 AM

    nice

    ReplyDelete
  24. AnonymousFebruary 11, 2010 at 8:09 AM

    Wicked, Cheers

    ReplyDelete
  25. davidApril 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

    ReplyDelete
  26. UnknownApril 15, 2010 at 11:24 AM

    Thanks a lot..its working now..

    ReplyDelete
  27. AnonymousJune 23, 2010 at 7:09 PM

    Thanks,its working

    ReplyDelete
  28. ArunsaiJune 28, 2010 at 1:07 AM

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

    ReplyDelete
  29. AnonymousJuly 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.

    ReplyDelete
  30. AnonymousJuly 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.

    ReplyDelete
  31. Marcelo Alves Fins e LimaAugust 26, 2010 at 11:40 AM

    Very Good! Thanks.

    ReplyDelete
  32. AnonymousOctober 6, 2010 at 11:13 AM

    thanks

    ReplyDelete
  33. AnonymousNovember 21, 2010 at 1:25 AM

    Champion!!!!

    ReplyDelete
  34. AnonymousJanuary 7, 2011 at 9:31 AM

    thanks for help

    ReplyDelete
  35. AnonymousJanuary 11, 2011 at 9:15 AM

    thanks everything is now working...

    ReplyDelete
  36. UnknownJanuary 21, 2011 at 8:46 PM

    Thanks very much ^________________^

    ReplyDelete
  37. AnonymousFebruary 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.

    ReplyDelete
  38. Vishnu_SinghMarch 11, 2011 at 6:35 PM

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

    ReplyDelete
  39. link wheelMarch 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.

    ReplyDelete
  40. Muhamed Ali Bin AbdillaMarch 23, 2011 at 5:55 AM

    This comment has been removed by the author.

    ReplyDelete
  41. GraceMay 29, 2011 at 11:58 AM

    having the same problem using windows 7. pls help.

    ReplyDelete
  42. Ibnu ThamrinJune 7, 2011 at 9:42 PM

    thanks. it's working for me

    ReplyDelete
  43. AnonymousJuly 21, 2011 at 4:51 AM

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

    ReplyDelete
  44. free auto insurance quotesJuly 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.

    ReplyDelete
  45. AnonymousAugust 17, 2011 at 10:48 AM

    Good work!Thanks a lot.Its working now

    ReplyDelete
  46. AnonymousNovember 8, 2011 at 7:20 AM

    thanks boss

    ReplyDelete
  47. simplyMiiiNovember 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!;)

    ReplyDelete
  48. LewisNovember 28, 2011 at 4:47 PM

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

    ReplyDelete
  49. link wheelFebruary 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)

    ReplyDelete
  50. amsJuly 25, 2012 at 9:51 AM

    Thanks a lot .its working

    ReplyDelete
  51. amsJuly 25, 2012 at 9:54 AM

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

    ReplyDelete
  52. MarcOctober 12, 2013 at 4:22 PM

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

    ReplyDelete
  53. RashidSeptember 29, 2014 at 11:55 PM

    Thank you so much, 100% helpful.

    ReplyDelete
  54. RichDecember 3, 2014 at 12:12 PM

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

    ReplyDelete
  55. UnknownFebruary 16, 2016 at 8:33 PM

    Thank you very much! Very very helpful!

    ReplyDelete
  56. chathura ravinAugust 22, 2016 at 7:50 AM

    greate,,,thanx

    ReplyDelete