Share via

SQL 2005 and SMS/MOM

  • Article

A lot of folks are asking about support for SQL 2005 with SMS 2003 and MOM 2005.  Neither of the current releases support SQL 2005.  This is planned for SP2 for SMS 2003 and discussions are continuing for MOM 2005.  I'm running the database for the current releases of both products on SQL 2005 and it seems very smooth - looking forward to customers being able to use it - but this is not officially supported yet and absolutely should not be done in production.

- Steve

Comments

  • Anonymous
    February 28, 2006
    Steve,

    We've heard rumors repeatedly from PSS referencing a hotfix in testing for SQL 2005....any truth to this?

    and if so, when is it coming? Any info is appreciated.
  • Anonymous
    March 01, 2006
    Good question and you are correct that there were some code changes required to support the MOM 2005 DB running on SQL 2005.  There should be some 'official' communication on this soon.

    - Steve
  • Anonymous
    March 01, 2006
    Steve,

    A hotfix was posted that mentions a fix, but the associated KBKB913801 is unavailable. Can you elaborate for us as to where this places support for MOM 2005 SP1 on SQL 2005? and what was contained in 913801?

    http://www.microsoft.com/downloads/details.aspx?FamilyID=596710cc-cf17-476f-a30c-8973612f4ac7&DisplayLang=en
  • Anonymous
    March 02, 2006
    That's what I was saying!  :)  Things are in the works to get this done - not everything is ready yet.  Once we have it all ready you will see information on what needs to happen.  

    - Steve
  • Anonymous
    March 27, 2006
    Are there any new updates.  I see there is a new hotfix at:
    http://www.microsoft.com/downloads/details.aspx?FamilyId=E5FC1871-1286-461D-BFCD-D32CF426E8C3&displaylang=en
    although KB915785 is not available.  
    I am currently stuck trying to decide whether to start with SQL 2005 or 2000 with MOM 2005.  Everything is paid for and we have licenses for both SQL 2000 and 2005, we are just waiting on the SQL situation to be taken care of.  Do you see any problems with starting out with SQL 2000 now and then upgrading once everything is sorted out?

    Thanks!
  • Anonymous
    March 29, 2006
    You can definately start with SQL 2000 - for ease of installation I would suggest starting with SQL 2000 SP3, get everything installed and then roll forward to SQL 2000 SP4.  Once the required fixes are released (not ready yet) you can roll forward to SQL 2005.

    Steve