Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

windows xp update server 2005 sp2 fails to install


  • Please log in to reply
No replies to this topic

#1 TravisMcgee

TravisMcgee

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:05:12 PM

Posted 15 October 2009 - 12:25 PM

Yesterday I downloaded and installed latets WinXP updates. Was not able to install Server 2005 SP2 update. Found following information from their support website:

http://support.microsoft.com/kb/957008

When you try to install a security update for Microsoft SQL Server 2005 Service Pack 2, Microsoft SQL Server 2005 is not successfully updated. This issue occurs because the rollback process for the security updates incorrectly removes the SQL Server 2005 service accounts from the respective local SQL Server service groups.

CAUSE: This issue occurs because the rollback process for security updates incorrectly...This issue occurs because the rollback process for security updates incorrectly removes the SQL Server 2005 service accounts from the respective local SQL Server service groups. The permissions are granted to local service groups and not to the service accounts. Therefore, the services cannot access the required resources, and the services cannot start.

RESOLUTION: To resolve this issue, follow these steps:

1. Identify the SQL Server 2005 service...To resolve this issue, follow these steps:


Identify the SQL Server 2005 service group that is located on your computer. To do this, follow these steps:


a. Click Start, click Run, type compmgmt.msc, and then press ENTER.

b. Expand Local Users and Groups, and then click Groups.

2. The SQL Server 2005 service group starts with "SQLServer2005." Identify each group, and then double-click to determine the group membership. If the group membership is empty, go to step 3. If the group membership is not empty, check the next group.

3. In the Services Microsoft Management Console (MMC) snap-in, determine the service account for the SQL Server 2005 services.

To open the Services snap-in, click Start, click Run, type services.msc, and then press ENTER.


4. The names of SQL Server services start with "SQL Server." For example, "SQL Server (MSSQLSERVER)" is a SQL Engine service for the default instance of SQL Server. To determine whether this service is from SQL Server 2005, follow these steps:

a. Right-click the service, and then click Properties.

b. Locate the program file of this service. This file is shown in the Path to executable area.

c. Right-click the file name, the properties, and the version. The file version should begin with either "9.0" or "2005.90."


5. In the Computer Management MMC snap-in, double-click the service group name that you located in step 2. Determine whether the service account entry is missing in the service group. If the service account entry is missing, click Add, type the service account name in the Enter the object name to select dialog box, and then click OK.

Note To open the Computer Management MMC snap-in, click Start, click Run, type compmgmt.msc, and then press ENTER.

6. In the Services MMC snap-in, start the SQL Server services.

Note To open the Services snap-in, click Start, click Run, type services.msc, and then press ENTER.

I followed these steps. The problem I am having is I do not understand file version and what I need to do to correc this. Thank you.

BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users