Solved

SQL Server 2005 SP2

Posted on 2013-06-24
7
552 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
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

910 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now