SQL Server 2005 SP2

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?
LVL 1
Tahir2008Asked:
Who is Participating?
 
Tahir2008Connect With a Mentor Author Commented:
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
 
Tahir2008Author Commented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Tahir2008Author Commented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
would it be better just to install a dedicated machine with SQL?
Probably.  You did not mention that was SBS.
0
 
Tahir2008Author Commented:
Sorry, it is a SBS 2008 server.
0
 
Tahir2008Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.