SQL information from the Partner newsgroups

In this Issue:

TOP SUPPORT ISSUES

NEW & UPDATED KB ARTICLES

NEW & TOP DOWNLOADS

NEW WEBCASTS

 

RECENT SUPPORT ISSUES

===================

Issue

———-

 

 

When you tied to install security update 948109, you encountered the following error:

 

Product Installation Status

Product                   : SQL Server Database Services 2005 (LPI)

Product Version (Previous): 3042

Product Version (Final)   :

Status                    : Failure

Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup

Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB948109_sqlrun_sql.msp.log

SQL Express Features      :

Error Number              : 29512

Error Description         : MSP Error: 29512  SQL Server Setup was unable

add user NT AUTHORITY\SYSTEM to local group

PACIFICHYDRO\SQLServer2005MSSQLUser$PHMELUTIL4$LPI.

 

Analysis

——–

This issue might occur because of one of the following reasons:

 

1: An operation has removed the local groups for the initial installation of SQL Server 2005.

2: An operation has changed the security identifiers (SID) for the local groups.

3: You have manually deleted the group.

 

 

Resolution

————–

1>           Go to the following Reg path

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup

2>           Backup the Registry

3>           Remove the following registry subkeys that store SID settings: ( Whichever is present )

 

o HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\SQLGroup

 

o HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\AGTGroup

 

o HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\FTSGroup

 

o HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\ASGroup

Note In these registry subkeys, MSSQL. X is a placeholder for the corresponding value on a specific system. You can determine MSSQL. X on a specific system by examining the value of the MSSQLSERVER registry entry under the following registry subkey:

 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\ 

 

 4> Re-run setup.

 

 

NEW & UPDATED KB ARTICLES

=========================

 

Access

——

956838  Description of the Access 2007 hotfix package: August 26, 2008

http://support.microsoft.com/default.aspx?scid=kb;EN-US;956838

 

SQL

—-

956909  The SQL Server 2008 builds that were released after SQL Server 2008 was released

http://support.microsoft.com/default.aspx?scid=kb;EN-US;956909

 

 

NEW & TOP DOWNLOADS

====================

 

Microsoft SQL Server 2008 Express with Tools

http://www.microsoft.com/downloads/info.aspx?na=22&p=5&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d7522a683-4cb2-454e-b908-e805e9bd4e28%26DisplayLang%3den

 

Microsoft SQL Server 2008 Express with Advanced Services

http://www.microsoft.com/downloads/info.aspx?na=22&p=6&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3db5d1b8c3-fda5-4508-b0d0-1311d670e336%26DisplayLang%3den

Microsoft SQL Server Protocol Documentation

http://www.microsoft.com/downloads/info.aspx?na=22&p=8&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d91ef5106-944a-41e1-b3a0-5bd3f2356f32%26DisplayLang%3den

SQL Server 2005 Best Practices Analyzer

http://www.microsoft.com/downloads/info.aspx?na=22&p=10&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dda0531e4-e94c-4991-82fa-f0e3fbd05e63%26DisplayLang%3den

  

Security Update for Access Snapshot Viewer 2002 (KB955440)

http://www.microsoft.com/downloads/info.aspx?na=22&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d34b655f8-1922-4246-94ca-ed381c3e3b13%26DisplayLang%3den

Office Protocol Documentation

http://www.microsoft.com/downloads/info.aspx?na=22&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3de7a23d42-0835-440f-9400-badfe9672b21%26DisplayLang%3den

 

NEW WEBCASTS

============               

 

Lunch and Learn Webcast Series – All About SQL 2008

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032387909&EventCategory=2&culture=en-US&CountryCode=US

TechNet Webcast: Protect SQL Server 2008 with Data Protection Manager 2007 (Level 300)

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032384075&EventCategory=4&culture=en-US&CountryCode=US

Comments are closed.

Post Navigation