Results 1 to 5 of 5

Thread: MS SQL Server 2005 SP3 Update Install Problem

  1. #1
    Join Date
    Nov 2009
    Posts
    1

    MS SQL Server 2005 SP3 Update Install Problem

    Hello, I have an issue with installation of update of SQL Server 2005 SP3. MS Updates shows that I have successfully installed the update numerous times, but I am always immediately prompted to install it again. I receive no error codes. It just shows to succesfully have updated.
    I'm running Windows/XP.
    Can anyone help?
    Thanks, ekfog

  2. #2
    Join Date
    May 2008
    Posts
    2,945

    Re: MS SQL Server 2005 SP3 Update Install Problem

    In this case, SP3 is not getting installed due to missing msp files in %windir%\installer folder. These are not automatically deleted and must have been manually deleted. The best place is to start is to review the SQL Server installation logs. For more information you need to check out the following link. .MSP files are automatically created for service pack or cumulative update or hotfix installs and store the differential changes between the previous and current install. These are useful if the patch needs to be uninstalled

  3. #3
    Join Date
    May 2008
    Posts
    3,516

    Re: MS SQL Server 2005 SP3 Update Install Problem

    Hi, I am also getting the same problem and I repair the SQL Server 2005 instance by using Add or Remove Programs. You just follow the steps as:
    1)In Control Panel, open Add or Remove Programs.
    2)In the Currently installed programs list, click the instance of Microsoft SQL Server 2005 to repair and then click Change.
    3)In the Component Selection page, select Database Engine and then click Next.
    4)In the Feature Maintenance page, select Database Engine and then click Next. The SQL server installation wizard starts.
    5)Click Next on the System Configuration Check page.
    6)In Change or Remove Instance page, select Complete the suspended installation.
    7)Click Next on the Error and Usage Report Settings page. Optional, you can select one or both the boxes on this screen.
    8)Click Install on the Ready to Update page.
    9)Click Next on the Setup Progress page.
    10)Click Finish on the Completing Microsoft SQL Server 2005 Setup page.

    It will solve your problem. Just try it.

  4. #4
    Join Date
    Jan 2006
    Posts
    3,792

    Re: MS SQL Server 2005 SP3 Update Install Problem

    It seems that the problem is due to windows xp .I suggest you that install MS SQL Server 2005 on windows XP SP2 before upgrading to SP3.Make sure that the language of SQL matches the language of your Operating System. The fact is that Windows has decided to put msxml6 under System File Protection for SP3, and this change conflicts with the pre-existing requirements of installing SQL Server. In your specific case the problem is related to installing a different language of SQL than the OS you have. In between installation msxml64.dll attempts to make a language change that is not allowed under System File Protection.
    I hope this will help you to get rid out of problem.

  5. #5
    Join Date
    Apr 2008
    Posts
    3,424

    Re: MS SQL Server 2005 SP3 Update Install Problem

    I think there is problem in a updates so that it prompt you to installed it again. When you are downloading any update it checks that your updates are up to date. So it's checks the difference between UTC and local time and based on that it downloaded the updates. Please set your date and time correctly so that your system downloads only new updates.

Similar Threads

  1. Replies: 6
    Last Post: 11-05-2010, 03:01 AM
  2. Replies: 16
    Last Post: 16-10-2009, 12:52 PM
  3. SQL server 2005 SP2 fails to install
    By Martin100 in forum Windows Update
    Replies: 4
    Last Post: 14-07-2008, 12:35 PM
  4. Won't update: Microsoft SQL Server 2005 Express Edition SP2
    By chimeratei in forum Windows Update
    Replies: 4
    Last Post: 12-06-2008, 03:01 AM
  5. Critical Update for SQL Server 2005 Service Pack 2 (KB 933508)
    By kusumanabh in forum Small Business Server
    Replies: 1
    Last Post: 13-03-2007, 11:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,642,931,196.64006 seconds with 17 queries