tag:blogger.com,1999:blog-4414432572587218573.post5612683189752799790..comments2023-05-06T15:20:16.638+02:00Comments on Thoughts on Azure, OMS & SCOM: SCOM Discovery Wizard doesn’t workMarnix Wolfhttp://www.blogger.com/profile/09487479325587450184noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-4414432572587218573.post-54107119268454987672014-10-28T21:26:36.073+01:002014-10-28T21:26:36.073+01:00don't change the DB to single user mode, you w...don't change the DB to single user mode, you will get stuck.<br />I changed it to single user mode and<br />I kept trying to run the last query but I couldn't as other process accessing the DB and each time I kill a process another starts<br /><br />this Query works immediately <br /><br />alter database [] set enable_broker with rollback immediateMinahttps://www.blogger.com/profile/13065976195785938342noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-19928013480350330332012-12-26T22:37:28.431+01:002012-12-26T22:37:28.431+01:00By the way, I'm using SCOM 2012, and was exper...By the way, I'm using SCOM 2012, and was experiencing the same Discovery Wizard problem. I went through the same SQL Server steps Marnix posted above and it resolved my issue. Thanks Marnix!Anonymoushttps://www.blogger.com/profile/15801761967277341642noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-64575093813049877412010-08-04T09:59:03.399+02:002010-08-04T09:59:03.399+02:00Hi Dom.
Disable the SDK service on the RMS and th...Hi Dom.<br /><br />Disable the SDK service on the RMS and the Health Service on all the MS servers.<br /><br />Close down SQL Management Studio and start it. Now you should be able to access the DB and run the queries against it.<br /><br />When more direct contact is needed, please leave your mailaddress here.<br /><br />Cheers,<br />MarnixMarnix Wolfhttps://www.blogger.com/profile/09487479325587450184noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-84103956816275679682010-08-04T09:12:04.009+02:002010-08-04T09:12:04.009+02:00Hi Dom.
Do I understand it correctly that the RMS...Hi Dom.<br /><br />Do I understand it correctly that the RMS also runs SQL Server, hosting the SCOM DBs?<br /><br />Cheers,<br />MarnixMarnix Wolfhttps://www.blogger.com/profile/09487479325587450184noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-89680389694116073502010-08-04T07:04:54.877+02:002010-08-04T07:04:54.877+02:00After passing sucessfully ALTER DATABASE Operation...After passing sucessfully ALTER DATABASE OperationsManager SET SINGLE_USER the database is shown as Single User.but when running ALTER DATABASE OperationsManager SET ENABLE_BROKER I am getting Msg 5011, Level 14, State 5, Line 1<br />User does not have permission to alter database 'OperationsManager', the database does not exist, or the database is not in a state that allows access checks.<br />Msg 5069, Level 16, State 1, Line 1<br />ALTER DATABASE statement failed.<br />it seems conflictual!!! I could not run the command because it is in single user mode ... but I need to be in single user mode to be able to run the command... something is wrong!!!<br /><br />Thanks,<br />DomDominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-73585277113540748922010-08-04T02:44:26.948+02:002010-08-04T02:44:26.948+02:00I think I found the issue but not sure how to reso...I think I found the issue but not sure how to resolve it... All SCOM Services are stopped but I have 27 connections to the Database??? Could it be from the MS themselves? How to drop them and or to locate who is connected?<br /><br />Thanks,<br />DomDominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-39065786963196320612010-08-04T01:37:59.901+02:002010-08-04T01:37:59.901+02:00Hi Marnix,
No other DB on this server... it is th...Hi Marnix,<br /><br />No other DB on this server... it is the RMS and it has its own DB on its own SQL Server locallly.<br /><br />Thanks,<br />DomDominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-40715029936708373932010-08-03T12:28:12.182+02:002010-08-03T12:28:12.182+02:00Hi Dom.
Normally this should run in a couple of m...Hi Dom.<br /><br />Normally this should run in a couple of minutes at the most. But important here is what other SQL DBs the server is hosting.<br /><br />This blogposting is based on some personal experience on a dedicated SQL server.<br /><br />Cheers,<br />MarnixMarnix Wolfhttps://www.blogger.com/profile/09487479325587450184noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-53386333055178965752010-08-03T02:29:52.536+02:002010-08-03T02:29:52.536+02:00Hello,
Hiow long the second command
ALTER DATABASE...Hello,<br />Hiow long the second command<br />ALTER DATABASE OperationsManager SET_SINGLE_USER WITH ROLLBACK IMMEDIATE shpould run?<br /><br />It is already over 10 minutes...<br /><br />Thanks,<br />DomDominiquehttps://www.blogger.com/profile/01255525778656066370noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-87315548300117210242010-02-06T16:49:58.477+01:002010-02-06T16:49:58.477+01:00I was following a KB from Microsoft http://support...I was following a KB from Microsoft http://support.microsoft.com/kb/941409 and they dont have the second execute line that you have in their article.<br /><br />ALTER DATABASE OperationsManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE<br /><br />so when i tried to execute the <br />ALTER DATABASE OperationsManager SET ENABLE_BROKER <br />the query just keeps runnin with no respone or results.<br /><br />Using an eval version of SQL2008 and Ops Manager 2007 R2Jolivenomhttps://www.blogger.com/profile/08381326228993654198noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-90862100559506252532009-04-20T22:47:00.000+02:002009-04-20T22:47:00.000+02:00Hi HunterX3.
Now I see: we are talking about two ...Hi HunterX3.<br /><br />Now I see: we are talking about two different products. SCE (System Center Essentials) is not SCOM (System Center Operations Manager), eventhough there are certain things alike.<br /><br />SCE is however certainly not distributed as SCOM is, so there is no such thing as a RMS and a MS. SCE is kind off an 'all-in-one' product: a bit of SCOM, WSUS & SCCM.<br /><br />My blog is solely about SCOM and not SCE. I have not really worked with SCE.<br /><br />Having said that, I can give it a try to help you. However, I can't give any guarantees.<br /><br />Nor will my next reply be swift since I will be onsite at multiple customersites so I do not have much time to react.<br /><br />So let's start.<br /><br />1 When was SCE still up & running before this all started? Better, after what action(s) started the problems with SCE? The more detail you can give the better.<br /><br />2 You talk about deleting computer-accounts. Did you remove them from SCE BEFORE the removal from AD?<br /><br />You say you tried. How? Did you delete the Agents or did you run an uninstall (would only be succesful if the computeraccounts were still present in the AD).<br /><br />Are these deleted computeraccounts still present in SCE?<br /><br />3 Are those computer-accounts servers as well?<br /><br />4 What about SCE? Is it all installed on one server (SCE and SQL)?<br /><br />5 Are all SCE & SQL related services still up & running?<br /><br />6 Is the SCE server account still present and OK in AD?<br /><br />7 Is the SQL server account still present and OK in AD?<br /><br />8 When I read the error about the Agent not starting on a server, with this error check these pages: http://blogs.technet.com/smsandmom/archive/2008/04/30/opsmgr-2007-healthservice-service-fails-to-start-with-25362-warning.aspx <br /><br />and<br /><br />http://www.eggheadcafe.com/conversation.aspx?messageid=31822881&threadid=31822881.<br /><br />9: The presence of an SCP can be seen in the AD. Check here: http://social.technet.microsoft.com/Forums/en-US/systemcenterdeployment/thread/b42152cc-4b6a-4df1-86bb-6942ad58d88e<br /><br /><br />An SCP is a way to help SCOM/SCE Agents - which haven't been pushed from SCOM/SCE to find their configurationinformation.<br /><br />Suppose you have an OS image with the SCOM/SCE Agent included. When this OS starts, the Agent will contact the SCP for it's configurationinformation (to what server does it have to report).<br /><br />But SCP is only interesting when one doesn't push the SCOM/SCE Agent from SCOM/SCE.<br /><br />Good luck with it all.Marnix Wolfhttps://www.blogger.com/profile/09487479325587450184noreply@blogger.comtag:blogger.com,1999:blog-4414432572587218573.post-42332253091350609942009-04-20T20:37:00.000+02:002009-04-20T20:37:00.000+02:00Pretty much nothing in Security Center Essentials ...Pretty much nothing in Security Center Essentials Monitoring is working. No alerts are coming in. The SCE server cannot communicate with the clients because the client's OpsMgr Health Service service won't start. That errors with: The OpsMgr Health Service service terminated with service-specific error 2147500037 (0x80004005). <br /><br />As for the events I posted before, the second one is 29106/OpsMgr Conig Service/Warning. The first one I cannot find. I am also seeing these: Configuration state of OpsMgr Health Service "{44293b59-9080-52ec-b353-dbfcbd6da198}" running on "sceservername" may be out of date. It should contact OpsMgr Config Service to synchronize its configuration state. Those are 29102/OpsMgr Config Service/Information<br /><br />In AD, we created a overall OU for the company that we placed all of our sub OU's under, but those were for users, not computers. We did delete a bunch of computer accounts and I tried to stop them from being monitored under the Agent Managed under Administration. I did not remove any management packs that I am aware of.<br /><br />You ask: Did SCOM use SCP (Service Connection Point) which has been removed? I don't know what that is so I'm guessing not. Is there a way to check?HunterX3https://www.blogger.com/profile/07896912841437647142noreply@blogger.com