Install SQL Server 2005 error

  • I am installing SQL Server 2005 workgroup edition on a windows 2003 server SP1.

    While installing i had the error:

    "Failure creating local group SQLServer2005SQLBrowserUser$RAYRODC"

    I read the description and it is something related to Read-Only Domain controller (RODC)..

    anyone knows how to turn around this problem???

  • come on.

    no one ever faced this problem??

  • Do you hold admin rights on this domain? If not try doing that...

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • I have tried using the domain administrator account but still failed.

    I guess the problem is with the following option

    While installing SQL, we need to specify service accounts login.

    i have tried:

    --Local System

    --Use a domain user account with administrator domain name but still failed,

    Note that am installing on a Windows 2003 Server SP1..

    could upgrading to SP2 solve the issue??

    If not, what else could it be?

    regards

  • Are you local admin on the machine?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • This appears to be a common problem when installing SQL Server on a Read-Only Domain Controller;

    From MS

    "On a domain controller, the Local Users and Groups tool is not available. Applications that directly run on a domain controller create users or groups in the User object in the Domain class. When you install SQL Server 2005, the SQL Server 2005 Setup program must create additional groups. However, you do not have the write permission on a RODC. Therefore, the SQL Server 2005 Setup program cannot create these groups.

    For more information about RODCs, visit the following Microsoft Web site:

    http://technet2.microsoft.com/windowsserver2008/en/library/ce82863f-9303-444f-9bb3-ecaf649bd3dd1033.mspx?mfr=true"

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • any idea how to give write access and creating local user group on the RODC??

    I am still failing in installing sql 2005

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply