Link to home
Start Free TrialLog in
Avatar of HKFuey
HKFueyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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?
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

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.
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.
Avatar of HKFuey

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HKFuey

ASKER

Thanks for the help (Decided to re install, looks OK now)