SQL Server 2005 question

ITdude

Hi,

I just got done doing an install of SQL Server 2005. I was about to update to either SP1 or SP2.

Does anyone know if there are any issues with Service Pack2, or is it okay just to jump directly to it versus SP1?

Any educated comments would be appreciated.

Thanks

royal

The only thing I know in regards to SQL 2005 SP2 is that it is not supported if you are installing SCOM.

ITdude

Thanks. So if you are installing SCOM SP1 is preferred?

royal

Correct. The prerequisite check even tells you it wants SP1. I then did some digging online and saw that SQL 2005 SP2 is not supported for SCOM at the current moment. This of course could change any day.

ITdude

yea somewhere around the time when SQL Server 2008 is released!

blargoe

I made the mistake of installing SCOM on SQL 2005 SP2. DON'T DO IT!!! (if you're planning on installing an SCOM database or reporting).

Otherwise, check with the vendor of the application that you're using that needs a database on your SQL Server. Generally, there aren't any issues that I have seen, but keep in mind you can't roll back without a reinstall and the database backups between sp versions are incompatible.

ITdude

The software I am planning to use requires that reporting services be installed with SQL 2005. SO, are you saying there are issues with SP2? The company said they have not had any problems that they are aware of with sp2. Does not necessarily mean anything though.

blargoe

Not specifically problems with sp2, just SCOM 2007 when used with SP2. You should be fine.

ITdude

Okay great! Thanks for the update. I have sp2 sitting here waiting to install but didn't want to jump the gun till I was sure...

Thanks