February 26, 2009 at 2:12 am
Hi,
I am not able to install SQL Server 2005 SP3 for Database Services, Analysis Services in SQL Server 2005 SP2 installed. The following error in Summary.txt file i found. What could be the reason for this?
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB955706_sqlrun_as.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
February 26, 2009 at 2:22 am
Hi,
See if this KB helps.
http://support.microsoft.com/kb/925976
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 26, 2009 at 2:53 am
The article says, we should modify the registry key's for the groups
I have in the registry, SQLGROUP, AGTGROUP and FTSGROUP is having some value.
to install SP3, do ineed to delete this key values from the gropu? or do i need to delete entire group?
please clarify....
February 26, 2009 at 2:55 am
Is there any examples for psgetsid?
February 26, 2009 at 2:59 am
Little bit of Googling will surely help. However see this link.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 5, 2010 at 12:22 am
Please go through this link
http://support.microsoft.com/kb/925976
------
As mentioned in the above link..
1) Download the Pstools from the below link
http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx
2) Copy it to the server and from command prompt( go to the path where u saved the Pstools)
type -- psgetsid \\servername
SID value will be displayed.
Ex: SID for \\servername:
S-1-x-xx-xxxxxxxxxxxx-xxxxxxxxxx
Copy the above SID value..
3) go to command prompt.. type regedit
go to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
replace SID value for below groups with the above SID value by right clicking the particular group -> click modify -> paste the new SID value -> click OK
SQLGroup
AGTGroup
FTSGroup
modify the existing SID value with the above SID value
--->
To modify SID value of ASGroup
go to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup
Where MSSQL.X may be MSSQL.2 / MSSQL.3
modify the existing SID value with the above SID value
and start the installation.. it will work
🙂
September 28, 2010 at 2:51 pm
I have this exact same issue except that for me I installed SQL 2005 got the server up and running and then promoted to a DC. (It is a really small network with only 3 servers and the SQL server is pretty much sitting idle) Now there are no local accounts only domain accounts. Any idea on what I need to do about the SID's?
January 5, 2011 at 9:32 am
I tried to update the three registry entries AGTGroup, FTSGroup, and SQLGroup, but that did not solve the problem.
However, when I deleted those three registry entries and restarted the computer, the installation of the service pack went without problems.
After the installation had completed, I checked the registry again. The three registry entries were recreated with correct values during the installation.
This worked with SP4 and probably works with the earlier service packs as well.
:-):-):-)
November 15, 2013 at 5:35 am
Hi,
Years later I have the same problem. And I have another question related to this issue. Kindly excuse when it is a silly question.
Do I have to delete the complete subkey (eg AGTGroup-> right click -> delete) or just the value it contains (eg: AGTGroup -> right click -> modify -> delete the String in "Value data" -> click ok)
Thanks for answering in advance!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply