Solved

SQL Server 2005 SP2

Posted on 2013-06-24
7
565 Views
Last Modified: 2013-07-22
Hi,

I just installed SQL Server 2005 SP2 and it completed without a problem however when I run Microsoft SQL Server Management Studio Express and run the query Select @@version it shows SP1 and not SP2.

How can I successfully re-install the SP2 update?
0
Comment
Question by:Tahir2008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 1

Author Comment

by:Tahir2008
ID: 39272833
When I run the MS SQL Server 2005 SP2 setup it updates the following files but says failure as the status:


SQL Server Native Client X64 - Failure
Backward Compatability - X64 - Failure
Microsoft SQL Server VSS Writer - X64 - Failure

When I then try to access the log files it says they cannot be found.

Any ideas?
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39272887
The install seems to have failed.  I would recommend trying to install directly SP4 since SP2 is not supported anymore.  With some luck it will do the clean up for you.

If that does not work or you can't' install SP4 for some reason, I would suggest uninstalling everything and reinstalling back SQL2005 then SP4.  You will probably end up spending much more time trying to figure out why the first install went wrong than starting from scratch.  Also please make sure you are installing the right binaries versions (x86 vs x64)
0
 
LVL 1

Author Comment

by:Tahir2008
ID: 39272914
Re-installing all the default components on a SBS 2008 machine would be complex and could cause more problems, would it be better just to install a dedicated machine with SQL?
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39272919
would it be better just to install a dedicated machine with SQL?
Probably.  You did not mention that was SBS.
0
 
LVL 1

Author Comment

by:Tahir2008
ID: 39272927
Sorry, it is a SBS 2008 server.
0
 
LVL 1

Accepted Solution

by:
Tahir2008 earned 0 total points
ID: 39323478
The solution was to install all the updates listed on the SBS server which then eventually installed SP2 for SQL 2005 so no complex re-install of components was necessary.
0
 
LVL 1

Author Closing Comment

by:Tahir2008
ID: 39345082
None of the replies answered the question and resulted in me having to test the process in a virtual environment to ensure it worked as required.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question