Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have SQL Server 2005 SP1 currently and VS 2005. We're planning on installing SP4 for Sql Server 2005.

Question: Are there any specific requirements for this install or known negative effects that we should know about?

Thank you.

share|improve this question

migrated from stackoverflow.com Jan 27 '12 at 0:06

This question came from our site for professional and enthusiast programmers.

    
Have you tried it on a VM? –  p.campbell Jan 26 '12 at 18:44
    
@p.campbell: No. –  Becky Jan 26 '12 at 18:50
    
How about save some time, headache, and frustration, and do the work/testing in a VM? How can you rely on answers on the internet and not test anything? –  p.campbell Jan 26 '12 at 18:54
    
Of course we will test first. Talking about saving time, though, how about first finding out if we can install it in the first place - do I first need to have previous SPs? Will it have an effect on VS's ability to connect to SQL? I couldn't find anything of value on the web, so I thought I'd see if anyone here has any info that can help. –  Becky Jan 26 '12 at 19:08
add comment

1 Answer

You should "smoke test" in a testing environment whenever possible but, in general, SQL Server service packs have not been the cause of great difficulties in my experience (especially not with SQL Server 2005).

In response to your comment: SQL Service Service Packs are not "additive"-- that is you can install Service Pack 4 over any existing prior version without needing to load "prerequisites".

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.