Start Free Trial
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?
Microsoft SQL Server 2005
Microsoft SQL Server
Microsoft SQL Server 2008
8/22/2022 - Mon
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 Miller
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.
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?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Thanks for the help (Decided to re install, looks OK now)
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent