Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server 2005 SP2

Posted on 2013-06-24
7
Medium Priority
?
574 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

618 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