SQL 2005 Express permissions

I have a SQL 2005 Express database installed on my PC. I need to create a new DB but get message CREATE DATABASE permission denied in database master (Error 262)

The service is running under Local System User

Can anyone help?
HKFueyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kevin CrossChief Technology OfficerCommented:
How are you connecting to SQL?  In other words, are you using Windows or SQL authentication?  If the former, did you add your account as an administrator?  If the latter (or answer to last question is no), try logging in with the sa (database owner) account.
DBAduck - Ben MillerPrincipal ConsultantCommented:
Typically the default permissions is that the Local Administrators group has sysadmin access.  If you are not in the local admins group on the windows machine, then you will not have access to be sysadmin.  By default I believe that all users (non-admins) are users and can query databases, but cannot create.
HKFueyAuthor Commented:
I cannot log in as sa, the user is disabled. When I try enabling I get a permission error.

All I need is an SQL Express database for my application, should I try reinstalling SQL?
Kevin CrossChief Technology OfficerCommented:
Did you check on whether the user you are logging in with is in the Local Administrators group?  The fact that you are getting errors whenever doing anything administrative suggests that you are not in the database owner role.  Therefore, you need to find an account that is ...  

If you do re-install, there is a step that asks if you want to add the current user as an admin.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HKFueyAuthor Commented:
Thanks for the help (Decided to re install, looks OK now)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.