Problem installing SQL 2005 on a Windows 2003 DC

Hot Topic

sql server 2000
What's Happened to Copy Objects in Import/Export Wizard?
SA account Locked out
How to call Integration Services Project from Web UI
How can I get primary key col and other two cols in the same table become one to one relationship.
How to flag a row and allow max one row flagged in the table.
SQL Server 2005 Nov 7 GA Installation
report viewer control wont display report !
Database Design Question
Query optimiser choosing bad query plan

SQL Server

2005 SP1 install, another can't authenticate...
question on namespaces
"Package failed validation from the ExecutePackage task" error
sql server 2005 on itanium 2 and SAN storage
FTP guaranteed delivery
Dynamic T-SQL steatment
Trouble customizing noise word list
"Current day" MDX
Sql to FoxPro Export
Temporary tables

Problem installing SQL 2005 on a Windows 2003 DC

Hello to all,

we try to install an SQL 2005 server on a Windows 2003 server that is also a Domain controller. In discussions of july last year, Dan Jones said :"Unfortunately in setup you cannot change the default account for all services. So there is absolutely no work around for this problem. This will absolutely be fixed by RTM - "

Can anybody help me in that way. We tried installing with our latest CDs (december 2005)

Answer this question

Problem installing SQL 2005 on a Windows 2003 DC

  • Luciano Resende

    It's not clear what your problem is. Are you having trouble installing If so, what is the behavior you're seeing.

  • chintanpatani

    I set up different security groups having the name of the desired groups:

    SQLServer2005DTSUser$SRV05FIL01

    SQLServer2005MSFTEUser$SRV05FIL01$MSSQLSERVER

    SQLServer2005MSOLAPUser$SRV05FIL01$MSSQLSERVER

    SQLServer2005MSSQLServerADHelperUser$SRV05FIL01

    SQLServer2005MSSQLUser$SRV05FIL01$MSSQLSERVER

    SQLServer2005NotificationServicesUser$SRV05FIL01

    SQLServer2005ReportingServicesWebServiceUser$SRV05FIL01$MSSQLSER

    SQLServer2005ReportServerUser$SRV05FIL01$MSSQLSERVER

    SQLServer2005SQLAgentUser$SRV05FIL01$MSSQLSERVER

    SQLServer2005SQLBrowserUser$SRV05FIL01

    Those groups have as members the user that is running the setup, domain-user and domain-admin.  The problem is still the same: error message: "Failure creating local group SQLServer2005SQLAgentUser$SRV05FIL01$MSSQLSERVER".

    As we have a DC, there is no way to declare local groups.

    I can send you the logfile if desired.

     

  • Bard-Erik Venheim

    The user that your running setup as doesn't have the correct permissions on the DC to create a new group. To work around this have the group created prior to running setup. In addition, if you don't have permission to add users to a group you can add the domain user to the group prior to running setup. During setup it'll check for the existence of the group and that the user is part of the group. If you set this up prior to running setup you don't need the create group and add to group permissions.

  • Namio Evangelista

    Create those groups on you 1st domain controller , force a replication of AD and you have all these groups on your new server . the installation of sql will now find these groups and set the security on it..

    Gtz

  • Jason E

    The problem is during installing. Despite the fact that we allocate a domain user account as user for the service accounts, we have a error message "Failure creating local group SQLServer2005SQLBrowserUser$<servername> and the installation does not continue.

  • Djgann

    Go ahead and log a bug using: http://lab.msdn.microsoft.com/ProductFeedback/

  • Problem installing SQL 2005 on a Windows 2003 DC
Answer this question