Wednesday, March 7, 2012

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)

It's not clear what your problem is. Are you having trouble installing? If so, what is the behavior you're seeing.|||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.|||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.|||

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.

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

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

No comments:

Post a Comment