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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy