sql server 2008 express server authentication mode

Posted on 2011-04-18
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?
Question by:leorocha
    LVL 8

    Expert Comment

    Is your account member of the SYSADMIN role ?

    Is your accound member of Windows Local administrators group ?

    Author Comment

    My OS is Windows 7 Home Premium and my account type is Administrator

    Author Comment

    FYI: I can`t set SYSADMIN role to my account. Also I can`t create any database
    LVL 8

    Accepted Solution


    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)

    Author Comment

    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


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now