AD Helper Service Error - Help Needed
|
From: Siv on 6 Jan 2010 05:42 Hi, I had a problem with the Reporting feature of SBS 2003 and had to remove and then reinstall the server tools / reporting feature. That is now working correctly and reports are being generated OK but for some reason this seems to have upset the AD Helper Service. Googling around and reading stuff on technet etc I have discovered that this is a logon user name problem or something user related. I have tried changing the AD Helper Service's logon details using both the system account and the administrator account and neither will allow the service to start. Can anyone advise me how to fix this. This is the error received when using the system account or the NT Authority\Local Service: Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7024 Date: 06/01/2010 Time: 10:26:25 User: N/A Computer: ACMSERVER Description: The SQL Server Active Directory Helper service terminated with service-specific error 3221225572 (0xC0000064). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Siv -- Martley, Near Worcester, UK
From: Ace Fekay [MVP-DS, MCT] on 6 Jan 2010 11:25 "Siv" <Siv(a)discussions.microsoft.com> wrote in message news:849EC2E9-C548-4577-9F4B-7B95C55231B0(a)microsoft.com... > Hi, > I had a problem with the Reporting feature of SBS 2003 and had to remove > and > then reinstall the server tools / reporting feature. That is now working > correctly and reports are being generated OK but for some reason this > seems > to have upset the AD Helper Service. > > Googling around and reading stuff on technet etc I have discovered that > this > is a logon user name problem or something user related. I have tried > changing the AD Helper Service's logon details using both the system > account > and the administrator account and neither will allow the service to start. > > Can anyone advise me how to fix this. > > This is the error received when using the system account or the NT > Authority\Local Service: > > Event Type: Error > Event Source: Service Control Manager > Event Category: None > Event ID: 7024 > Date: 06/01/2010 > Time: 10:26:25 > User: N/A > Computer: ACMSERVER > Description: > The SQL Server Active Directory Helper service terminated with > service-specific error 3221225572 (0xC0000064). > > For more information, see Help and Support Center at > http://go.microsoft.com/fwlink/events.asp. > > Siv > -- > Martley, Near Worcester, UK This service is specific to SQL. Please read the following. I hope you find it helpful. MSSQLServerADHelper Service. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active .... http://doc.ddart.net/mssql/sql2000/html/architec/8_ar_cs_9mhx.htm -- Ace This posting is provided "AS-IS" with no warranties or guarantees and confers no rights. Please reply back to the newsgroup or forum for collaboration benefit among responding engineers, and to help others benefit from your resolution. Ace Fekay, MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & MCSA 2003/2000, MCSA Messaging 2003 Microsoft Certified Trainer Microsoft MVP - Directory Services If you feel this is an urgent issue and require immediate assistance, please contact Microsoft PSS directly. Please check http://support.microsoft.com for regional support phone numbers.
From: Siv on 6 Jan 2010 20:04 Ace, Thanks for your help. Had a look at the document you gave the link for and I don't get why the ADHelper service isn't working, when I set it to run under the domain admin's account (as according to the document you pointed me to it says members of the "Power users" or local "Administrators" groups have the authority to start ADHelper Service)?? When I set it to the domain admin account it still gives the error reported below?? Any help with this gratefully accepted as I am now more confused. Siv -- Martley, Near Worcester, UK "Ace Fekay [MVP-DS, MCT]" wrote: > "Siv" <Siv(a)discussions.microsoft.com> wrote in message > news:849EC2E9-C548-4577-9F4B-7B95C55231B0(a)microsoft.com... > > Hi, > > I had a problem with the Reporting feature of SBS 2003 and had to remove > > and > > then reinstall the server tools / reporting feature. That is now working > > correctly and reports are being generated OK but for some reason this > > seems > > to have upset the AD Helper Service. > > > > Googling around and reading stuff on technet etc I have discovered that > > this > > is a logon user name problem or something user related. I have tried > > changing the AD Helper Service's logon details using both the system > > account > > and the administrator account and neither will allow the service to start. > > > > Can anyone advise me how to fix this. > > > > This is the error received when using the system account or the NT > > Authority\Local Service: > > > > Event Type: Error > > Event Source: Service Control Manager > > Event Category: None > > Event ID: 7024 > > Date: 06/01/2010 > > Time: 10:26:25 > > User: N/A > > Computer: ACMSERVER > > Description: > > The SQL Server Active Directory Helper service terminated with > > service-specific error 3221225572 (0xC0000064). > > > > For more information, see Help and Support Center at > > http://go.microsoft.com/fwlink/events.asp. > > > > Siv > > -- > > Martley, Near Worcester, UK > > > This service is specific to SQL. Please read the following. I hope you find > it helpful. > > MSSQLServerADHelper Service. > The MSSQLServerADHelper service is run under the localsystem account so that > it can add and remove objects registering SQL Server entities in the Active > .... > http://doc.ddart.net/mssql/sql2000/html/architec/8_ar_cs_9mhx.htm > > -- > Ace > > This posting is provided "AS-IS" with no warranties or guarantees and > confers no rights. > > Please reply back to the newsgroup or forum for collaboration benefit among > responding engineers, and to help others benefit from your resolution. > > Ace Fekay, MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & > MCSA 2003/2000, MCSA Messaging 2003 > Microsoft Certified Trainer > Microsoft MVP - Directory Services > > If you feel this is an urgent issue and require immediate assistance, please > contact Microsoft PSS directly. Please check http://support.microsoft.com > for regional support phone numbers. > > > . >
From: Ace Fekay [MVP-DS, MCT] on 6 Jan 2010 20:55 "Siv" <Siv(a)discussions.microsoft.com> wrote in message news:5CAF0372-46B4-46E6-890C-5065F48AECFF(a)microsoft.com... > "Ace Fekay [MVP-DS, MCT]" wrote: > >> "Siv" <Siv(a)discussions.microsoft.com> wrote in message >> news:849EC2E9-C548-4577-9F4B-7B95C55231B0(a)microsoft.com... >> > Hi, >> > I had a problem with the Reporting feature of SBS 2003 and had to >> > remove >> > and >> > then reinstall the server tools / reporting feature. That is now >> > working >> > correctly and reports are being generated OK but for some reason this >> > seems >> > to have upset the AD Helper Service. >> > >> > Googling around and reading stuff on technet etc I have discovered that >> > this >> > is a logon user name problem or something user related. I have tried >> > changing the AD Helper Service's logon details using both the system >> > account >> > and the administrator account and neither will allow the service to >> > start. >> > >> > Can anyone advise me how to fix this. >> > >> > This is the error received when using the system account or the NT >> > Authority\Local Service: >> > >> > Event Type: Error >> > Event Source: Service Control Manager >> > Event Category: None >> > Event ID: 7024 >> > Date: 06/01/2010 >> > Time: 10:26:25 >> > User: N/A >> > Computer: ACMSERVER >> > Description: >> > The SQL Server Active Directory Helper service terminated with >> > service-specific error 3221225572 (0xC0000064). >> > >> > For more information, see Help and Support Center at >> > http://go.microsoft.com/fwlink/events.asp. >> > >> > Siv >> > -- >> > Martley, Near Worcester, UK >> >> >> This service is specific to SQL. Please read the following. I hope you >> find >> it helpful. >> >> MSSQLServerADHelper Service. >> The MSSQLServerADHelper service is run under the localsystem account so >> that >> it can add and remove objects registering SQL Server entities in the >> Active >> .... >> http://doc.ddart.net/mssql/sql2000/html/architec/8_ar_cs_9mhx.htm >> >> -- >> Ace >> >> This posting is provided "AS-IS" with no warranties or guarantees and >> confers no rights. >> >> Please reply back to the newsgroup or forum for collaboration benefit >> among >> responding engineers, and to help others benefit from your resolution. >> >> Ace Fekay, MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & >> MCSA 2003/2000, MCSA Messaging 2003 >> Microsoft Certified Trainer >> Microsoft MVP - Directory Services >> >> If you feel this is an urgent issue and require immediate assistance, >> please >> contact Microsoft PSS directly. Please check http://support.microsoft.com >> for regional support phone numbers. >> >> >> . >> > > Ace, > Thanks for your help. > > Had a look at the document you gave the link for and I don't get why the > ADHelper service isn't working, when I set it to run under the domain > admin's > account (as according to the document you pointed me to it says members of > the "Power users" or local "Administrators" groups have the authority to > start ADHelper Service)?? > > When I set it to the domain admin account it still gives the error > reported > below?? > > Any help with this gratefully accepted as I am now more confused. > > Siv > -- > Martley, Near Worcester, UK If the service is actually the "The MSSQLServerADHelper service," then the article indicates that (quoted from link), "The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory." Also, according to the link, for the other SQL services, they should be run under an AD account, such as the Domain Admin account. Further researching this, apparently the error, "(0xC0000064)" indicates a "No Such User." Windows Server 2003-based domain controllers may incorrectly return the "NO_SUCH_USER (0xc0000064)" status code in response to logon requests http://support.microsoft.com/kb/942636 What service pack is SBS and SQL? Going further, I found the following, quoted from: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22745487.html "Make sure you have the current service packs for SQL and SBS 2K3 (if you have SBS OS 2K3). This was my issue, I was a service pack behind. Once going through the update process all was corrected and I no longer get the error. Currently SBS 2K3 is up to Service Pack 2 https://www.microsoft.com/downloads/details.aspx?familyid=95AC1610-C232-4644-B828-C55EEC605D55&displaylang=en and SQL 2005 is at Service Pack 2 http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx " I hope that helps. Ace
From: Siv on 10 Jan 2010 07:28
Ace, I think you may have hit the nail on the head. This SBS box has had SP2 applied and SQL Server 2005 also has all the latest SPs applied, however when I had to re-install the SBS Reporting I used the original SBS disks to re-install the reporting feature and of course they are not at SP2. I expect that this means that the system is SP2 and the SQL is at SP2 also but the version of the reports system is at the original version. Presumably if I applied SQL SP2 this might upgrade teh reports version to SQL SP2 and fix the issue? I would be interested to hear what you think of this? Siv -- Martley, Near Worcester, UK "Ace Fekay [MVP-DS, MCT]" wrote: > "Siv" <Siv(a)discussions.microsoft.com> wrote in message > news:5CAF0372-46B4-46E6-890C-5065F48AECFF(a)microsoft.com... > > > "Ace Fekay [MVP-DS, MCT]" wrote: > > > >> "Siv" <Siv(a)discussions.microsoft.com> wrote in message > >> news:849EC2E9-C548-4577-9F4B-7B95C55231B0(a)microsoft.com... > >> > Hi, > >> > I had a problem with the Reporting feature of SBS 2003 and had to > >> > remove > >> > and > >> > then reinstall the server tools / reporting feature. That is now > >> > working > >> > correctly and reports are being generated OK but for some reason this > >> > seems > >> > to have upset the AD Helper Service. > >> > > >> > Googling around and reading stuff on technet etc I have discovered that > >> > this > >> > is a logon user name problem or something user related. I have tried > >> > changing the AD Helper Service's logon details using both the system > >> > account > >> > and the administrator account and neither will allow the service to > >> > start. > >> > > >> > Can anyone advise me how to fix this. > >> > > >> > This is the error received when using the system account or the NT > >> > Authority\Local Service: > >> > > >> > Event Type: Error > >> > Event Source: Service Control Manager > >> > Event Category: None > >> > Event ID: 7024 > >> > Date: 06/01/2010 > >> > Time: 10:26:25 > >> > User: N/A > >> > Computer: ACMSERVER > >> > Description: > >> > The SQL Server Active Directory Helper service terminated with > >> > service-specific error 3221225572 (0xC0000064). > >> > > >> > For more information, see Help and Support Center at > >> > http://go.microsoft.com/fwlink/events.asp. > >> > > >> > Siv > >> > -- > >> > Martley, Near Worcester, UK > >> > >> > >> This service is specific to SQL. Please read the following. I hope you > >> find > >> it helpful. > >> > >> MSSQLServerADHelper Service. > >> The MSSQLServerADHelper service is run under the localsystem account so > >> that > >> it can add and remove objects registering SQL Server entities in the > >> Active > >> .... > >> http://doc.ddart.net/mssql/sql2000/html/architec/8_ar_cs_9mhx.htm > >> > >> -- > >> Ace > >> > >> This posting is provided "AS-IS" with no warranties or guarantees and > >> confers no rights. > >> > >> Please reply back to the newsgroup or forum for collaboration benefit > >> among > >> responding engineers, and to help others benefit from your resolution. > >> > >> Ace Fekay, MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & > >> MCSA 2003/2000, MCSA Messaging 2003 > >> Microsoft Certified Trainer > >> Microsoft MVP - Directory Services > >> > >> If you feel this is an urgent issue and require immediate assistance, > >> please > >> contact Microsoft PSS directly. Please check http://support.microsoft.com > >> for regional support phone numbers. > >> > >> > >> . > >> > > > > Ace, > > Thanks for your help. > > > > Had a look at the document you gave the link for and I don't get why the > > ADHelper service isn't working, when I set it to run under the domain > > admin's > > account (as according to the document you pointed me to it says members of > > the "Power users" or local "Administrators" groups have the authority to > > start ADHelper Service)?? > > > > When I set it to the domain admin account it still gives the error > > reported > > below?? > > > > Any help with this gratefully accepted as I am now more confused. > > > > Siv > > -- > > Martley, Near Worcester, UK > > If the service is actually the "The MSSQLServerADHelper service," then the > article indicates that (quoted from link), "The MSSQLServerADHelper service > is run under the localsystem account so that it can add and remove objects > registering SQL Server entities in the Active Directory." > > Also, according to the link, for the other SQL services, they should be run > under an AD account, such as the Domain Admin account. > > Further researching this, apparently the error, "(0xC0000064)" indicates a > "No Such User." > > Windows Server 2003-based domain controllers may incorrectly return the > "NO_SUCH_USER (0xc0000064)" status code in response to logon requests > http://support.microsoft.com/kb/942636 > > What service pack is SBS and SQL? Going further, I found the following, > quoted from: > http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22745487.html > > "Make sure you have the current service packs for SQL and SBS 2K3 (if you > have SBS OS 2K3). This was my issue, I was a service pack behind. Once going > through the update process all was corrected and I no longer get the error. > Currently SBS 2K3 is up to Service Pack 2 > https://www.microsoft.com/downloads/details.aspx?familyid=95AC1610-C232-4644-B828-C55EEC605D55&displaylang=en > and SQL 2005 is at Service Pack 2 > http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx " > > I hope that helps. > > Ace > > > . > |