January 5, 2011 at 4:39 am
error below occurs when installing SQL Server 2005 on a Vista machine:
"Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled"
Please assist.
Thanks
Thami Langa
January 5, 2011 at 5:52 am
Sounds like it's a problem with the windows/user account you're using to start the SQL Agent service.
Are you using a user account or a local system account to start the Agent service?
I found http://thedailyreviewer.com/dbsoftware/view/cant-start-sql-server-agent---wants-mssqlserveradhelper-107329922 which may contain some possible answers for you.
January 5, 2011 at 6:09 am
calvo (1/5/2011)
I found this link which may contain some possible answers for you.
The URL is hyperlinked to this forum post. Must be a typo!
This should be a good starting point.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 5, 2011 at 6:13 am
calvo (1/5/2011)
Sounds like it's a problem with the windows/user account you're using to start the SQL Agent service.Are you using a user account or a local system account to start the Agent service?
I found this link which may contain some possible answers for you.
The original question didn't say anything about starting SQL Server Agent.
However, an answer from MS Support in the thread you linked to (the link doesn't work by the way) contains some good advice about the MSSQLServerADHelper service.
Back on-topic: check the permissions of the service and if it is started or not.
More information about the service: http://msdn.microsoft.com/en-us/library/aa174517(sql.80).aspx
The link provided by calvo: http://thedailyreviewer.com/dbsoftware/view/cant-start-sql-server-agent---wants-mssqlserveradhelper-107329922
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 5, 2011 at 6:15 am
Adiga (1/5/2011)
@thamilanga,This should be a good starting point.
Yes, I also found the reference Buck Woody provided in a MSDN thread, but the only thing this article is useful for is how to navigate to the Services window on your computer.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 5, 2011 at 6:27 am
Koen (da-zero) (1/5/2011)
The original question didn't say anything about starting SQL Server Agent.However, an answer from MS Support in the thread you linked to (the link doesn't work by the way) contains some good advice about the MSSQLServerADHelper service.
Back on-topic: check the permissions of the service and if it is started or not.
More information about the service: http://msdn.microsoft.com/en-us/library/aa174517(sql.80).aspx
The link provided by calvo: http://thedailyreviewer.com/dbsoftware/view/cant-start-sql-server-agent---wants-mssqlserveradhelper-107329922
The OP didn't say much about anything. I was just doing my part in researching what might be causing the error. Ran into the article which made me think that it just might be a possibility that the Agent service isn't starting properly because of the logon account used.
As one poster stated in the link, he changed the Agent account logon and it worked for him.
January 5, 2011 at 7:12 am
Problem sorted,
I went to my services and set service MSSQLServerADHelper startup type to Automatic then changed logon as to Local System, and the installation went through without any issues
Thanks
January 5, 2011 at 7:21 am
thamilanga (1/5/2011)
Problem sorted,I went to my services and set service MSSQLServerADHelper startup type to Automatic then changed logon as to Local System, and the installation went through without any issues
Thanks
Glad that you found the solution and thanks for letting us know!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply