Dear Sirs,

I failed to install SQL Server 2005 Standard in cluster invironment.
Below please find the details.

I have created three Domain Groups, as listed below:
- DomainName\SQLServer;
- DomainName\SQLServerAgentGroup;
- DomainName\SQLServerSearch

and a domain account named Domainname\sqlservice.

When installing SQL Server Database Services, I got the following error:

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

SQL Server Setup was unable add user DomainName\sqlservice to local group
DomainName\SQLServerAgentGroup.

For help, click:
http://go.microsoft.com/fwlink?LinkI...oupMember%40x5


In the SQLSetup_SQL.log :

Error 29512. SQL Server Setup was unable add user DomainName\sqlservice to
local group DomainName\SQLServerAgentGroup.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlGroupMember
PerfTime Start: Do_sqlGroupMember : Thu Apr 26 17:42:58 2007
<Func Name='Do_sqlGroupMember'>
Local group DomainName\SQLServerAgentGroup doesn't exist
Failure adding user DomainName\sqlservice to local group
DomainName\SQLServerAgentGroup (5)
Error Code: 0x80070005 (5)
Windows Error Text: Access is denied.
Source File Name: sqlca\sqlsecurityca.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: Do_sqlGroupMember
Source Line Number: 1132

Error Code: 5


Setup has been run under Domain Administrator account.
I wonder if you could advise me anything on the above...

Thank you
Regards, Igor

Add the service accounts to the relavent groups before running the install.
It should now work fine.

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips


"Igor" <igor (AT) utilex (DOT) ru> wrote