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
56 comments:
Its working, thanks for the post.
Thanks! This really helped.
awesome. Thanks for the post!~
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
Thanks for the detailed post. Works great!
Thanks, helped a lot
thnak u very much..it worked...
Thanks a lot for your valuable steps...
Thanks.It helped me.
thank you so much it helped me a lot..
Thanks.
Thanks alot..its working..
awesome!!!
thanx a lot sir
I tried alot to solve.. but ur post helped me alot keep goingg
Thanks 4 this valuable info!
Thanks its really helpful. Thanks for this post
Thanks for your help solved it with the
In the system.web section added
identity impersonate="true" userName="username here" password="pw here"
Thanks
Thanks its working right now :)
best post!
really really helped!
thanks
thank you..very much....
u help me a lot....
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
thanks, it really works!!
nice
Wicked, Cheers
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
Thanks a lot..its working now..
Thanks,its working
'Member of the SqlServer SysAdmin role ' in the 'Available Privileges' box is missing
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.
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.
Very Good! Thanks.
thanks
Champion!!!!
thanks for help
thanks everything is now working...
Thanks very much ^________________^
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.
i use windows 7 .......... pls help me i have also this error.
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.
having the same problem using windows 7. pls help.
thanks. it's working for me
Thank you for your post sir. It really helped me. Two thumbs UP !!
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.
Good work!Thanks a lot.Its working now
thanks boss
thanks for the information ;) for almost a semester i can't use my sql server thanks for the help! GOdbless!;)
This makes me want to cry. it still isn't working
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)
Thanks a lot .its working
When connceting to sql server 2005 a network-related error has occuring .how to solve this
Thank you very much! Workly on SQL Server 2008 too!
Thank you so much, 100% helpful.
I'm using SQL 2014 and I still needed to go into my SQL 2005 and modify this setting...Thanks!
Thank you very much! Very very helpful!
greate,,,thanx
Post a Comment