Solved

SQL Server 2005 SP2

Posted on 2013-06-24
7
555 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Refresh Dev server with Production database 8 27
string fuctions 4 25
T-SQL: "HAVING CASE" Clause 1 23
Sql server, import complete table, using vb.net 9 32
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

813 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

17 Experts available now in Live!

Get 1:1 Help Now