Am installing WSS, single server install with default settings - fails with Exception E_ACCESSDENIED

Posted on 2009-04-22
Last Modified: 2012-05-06
Am trying to install WSS 3.0, single server install using default settings.  Install works fine.  When running configuration job, it rails on Task 5 With System.UnauthorizedAccessException
Access is denied.  ExceptionFromHResult: 0x80070005 (E_ACCESSDENIED)
Question by:wahoo2you
    LVL 15

    Expert Comment

    A lot of install/config fails are caused by the user ID not having the correct permissions.  The setup account needs the following:

    §   Domain user account.
    §   Member of the Administrators group on each server on which Setup is run.
    §   SQL Server login on the computer running SQL Server.
    §   Member of the following SQL Server security roles:
    ·          securityadmin fixed server role
    ·          dbcreator fixed server roleIf you run Stsadm commands that affect a database, this account must be a member of the db_owner fixed database role for the database.
    I attached the full list of user accounts and properties.  The attached is for MOSS but the setup user account has the same requirements for 3.0


    Author Comment

    Hi melli111 -
    Your comments are correct, but not helpful.
    I am doing a single server installation, using a domain user account that is a member of the Administrators group on the server.  I assume since embedded SQL was installed along with the single server installation that my user account was used.
    When you use default settings, it does not prompt for a separate SQL Server access account.
    I suspect there is something oddball in general regarding security at this client.  They are quite security conscious and perhaps they have turned off some service that is needed during the registration process.  I notice that the failure occurs while backing up the registry prior to update.
    LVL 15

    Expert Comment

    Yes.... I had the same error doing a single server install.  And even though I was using the embedded SQL for my content and configuration databases I still had to have the user ID doing the install have the SQL permissions on my SQL server.  Why?  I don't know, that I can't explain (I don't know much about SQL), but once I was given those permissions my configuration no longer gave me an access denied error.  I then get an error in a later step about already having a configuration database, so I deleted the previous config db and tried again and voila!  It was successful.

    Accepted Solution

    I discovered the answer to this question myself.  It had to do with the SQL connection string that was entered during configuration.
    Once I modified the connection string to include instance name and port, it worked just fine.
    Had nothing to do with permissions.
    Rich Elliott

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
    This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    732 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

    19 Experts available now in Live!

    Get 1:1 Help Now