[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

sql server 2008 express server authentication mode

Posted on 2011-04-18
5
Medium Priority
?
1,014 Views
Last Modified: 2012-05-11
I got the following error when I tried to modify Server Authentication mode to SQL Server and Windows Authentication mode:

xp_regread() returned error 5, 'Access is denied.' (Microsoft SQL Server, Error: 220001)

Any suggestions?
0
Comment
Question by:leorocha
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:jbvernej
ID: 35418870
Is your account member of the SYSADMIN role ?

Is your accound member of Windows Local administrators group ?
0
 

Author Comment

by:leorocha
ID: 35418965
My OS is Windows 7 Home Premium and my account type is Administrator
0
 

Author Comment

by:leorocha
ID: 35419004
FYI: I can`t set SYSADMIN role to my account. Also I can`t create any database
0
 
LVL 8

Accepted Solution

by:
jbvernej earned 1500 total points
ID: 35423784

Do you have UAC enabled in windows 7 (User account control , enabled by default) ?

repeat your action after launching program with 'RUN AS Administrator' (right click on EXE then Run as Administrator)
0
 

Author Comment

by:leorocha
ID: 35453041
UAC is disabled. Sorry for the delay in my response.  Finally I uninstalled 2008 Express and installed 2005 express and I solved my problem.

So I'll accept your last comment as a solution in order to reward your effort

Thanks!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Screencast - Getting to Know the Pipeline

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question