Installing MOM 2005 and SMS 2003 on SQL 2005 backend [updated!]

How to install MOM 2005 and SMS 2003 on a SQL 2005 backend

Andrzej's "IT Thoughts" Weblog — Mon, 03 Apr 2006 16:45:17 GMT

I posted an article on this topic if you are interested:
http://blogs.technet.com/alipka/articles/424009.aspx...

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend

Tim Mintner — Wed, 05 Apr 2006 02:48:07 GMT

Great post! This will answer a lot of questions that are posted in the newsgroups and on myitforum.

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend

Raghu Atluri — Wed, 05 Apr 2006 15:45:09 GMT

Very concise and precise document among the clutter of confusion we have regarding the installation of MOM 2005 on SQL 2005 backend.

Kudos to you for helping us all out and in turn helping the customers who are eagerly waiting for this upgrade.

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend

alipka — Mon, 10 Apr 2006 19:14:40 GMT

I noticed a few people have had problems with installing Reporting services on SQL 2005. I will work to update the article to be more specific. The issues are almost always around Reporting services application pools and accounts.

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend

alipka — Thu, 13 Apr 2006 15:00:53 GMT

Ok, I've updated the article. This should explain the procedure more clearly.

Installing MOM 2005 and SMS 2003 on SQL 2005 backend

Management Solution — Fri, 14 Apr 2006 05:38:55 GMT

For SMS 2003 SP2, It&nbsp;supports SQL Server 2005 already.
For MOM 2005 SP1, Microsoft released 3 hotfixes...

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend

alipka — Fri, 14 Apr 2006 10:15:04 GMT

Daniel,

You are right. But although for SMS 2003 there has been an official statement from us: http://www.microsoft.com/technet/prodtechnol/sms/smssp2/supconfig/0bdafa4a-71b3-4ed6-94bb-42a9f3986951.mspx?mfr=true

There's not a KB article or technet page on MOM 2005 and SQL 2005 supportability. This according to the PG is coming shortly.

BTW: Nice blog, I especially like your design!:)

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend

Daniel — Wed, 19 Apr 2006 05:02:17 GMT

Why don't you write a KB for it?

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend

alipka — Wed, 19 Apr 2006 09:07:56 GMT

I have already submitted this as a KB request. However:
1. There is already an article in the works AFAIK. (though not as detailed as mine)
2. The process of triaging KB articles is long, so I am afraid that it will take at least a month to release this as a KB. Therefore I posted it here.

andrew

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend [updated!]

payne — Wed, 24 May 2006 04:55:15 GMT

MOM and SQL 2005

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend [updated!]

alipka — Wed, 31 May 2006 14:40:46 GMT

So I got it into a KB article finally, but since I made updates during the tech review of this KB article my blog entry is still more uptodate then the KB:
http://support.microsoft.com/?id=918481

Anyway I think that such a process of sharing knowledge is far from ideal, I find wiki much more useful, when the knowledge gets accumulated into its final shape and flavor by inputs from everyone. The concept behind wiki is much more appealing then blogs or even more support pages and kb articles... we'll see.

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend [updated!]

Kelvin Lee-Ting — Thu, 22 Jun 2006 17:46:00 GMT

Great summary with all the gotchas.
The install works great if the SQL database is on the default instance. In my lab, I built a SQL 2005 SP1 server with 4 instances of SQL so that I can house all my MOM databases on one physical server.
I then used the momcreatedb.exe to install a new MOM 2005 SP1 database on one of the non-default instance, this went okay.
When I tried to install the management server on another server (a MS virtual server client) the install will fail. The error message is not very helpful.
I had previously done this with MOM 2005 RTM and SQL 2000 and it worked fine but I cannot seem to get it to work with MOM 2005 SP1 and SQL 2005 SP1.

re: Installing MOM 2005 and SMS 2003 on SQL 2005 backend [updated!]

alipka — Thu, 22 Jun 2006 18:05:07 GMT

Do you have the MSI log file? It should be in %temp%. This should give you more details about the cause of error. I am running mom 2005 sp1 on sql 2005 sp1 with OnePoint on non-default instance w/o problems but i have not installed the db via momcreatedb.