Sign in
The System Center Operations Manager Support Team Blog
This is the OpsMgr 2007 blog for the Microsoft support team. If you were looking for the SCOM 2007 or MOM 2005 blog then you are in the right place.
Tags
ACS
Admin Console
Administration
AEM
Agent
Alert
APM
App
Application Monitoring
Audit Collection Services
Authoring
Authoring Console
Authoring Resource Kit
authormps
AVIcode
Best Practice
Best Practices
Beta
Certificate
Client
Cluster
CM
Community
Config Service
ConfigMgr 2007
Connector
Console
Cross Platform
Cross Platform Update
CU3
CU4
Dashboard
Database
Deployment
Discovery
Documentation
Download
Error
Exchange
Gateway
GPO
Guide
Hotfix
How To
IIS
Install
KB Article
Linux
Maintenance Mode
Management Group
Management Pack
Management Packs
MOM
Monitor
Monitoring
MP Authoring
News
Notifications
Opalis
Operations Manager 2007 R2
Operations Manager 2012
OpsMgr
OpsMgr 2007
OpsMgr 2007 R2
OpsMgr 2012
Performance
PowerShell
R2
Report
Reporting
RMS
Rule
SCE
SCE 2007
SCE 2010
scom
SCOM 2007
Script
Service Level Dashboard
Service Manager
Setup
SNMP
SP1
SQL
Support Statement
TechNet Wiki
Tips
Tool
Training
Troubleshoot
Troubleshooting
tutorial
Unix
Update
Upgrade
User Interfaces (UI)
Webcast
Win2K8
Win7
WMI
Browse by Tags
TechNet Blogs
>
The System Center Operations Manager Support Team Blog
>
All Tags
>
sql
Tagged Content List
Blog Post:
OpsMgr 2007 R2 now supports SQL 2008 R2 SP1
J.C. Hornbeck
OM Community, System Center Operations Manager 2007 R2 now supports SQL Server 2008 R2 SP1 . Note: We will have the Supported Configuration posted in the next few weeks to make this more official, but feel free to go ahead and install it. Thanks! Nishtha ...read more
on
11 Oct 2011
Blog Post:
Setup and Upgrade in System Center Operations Manager 2012
J.C. Hornbeck
For the Operations Manager 2012 release, we have made some big changes in the setup and upgrade areas to make the deployment experience more simple, intuitive, and easy to use. In this post, I’m going to go through some of the major changes in the ...read more
on
12 Sep 2011
Blog Post:
OpsMgr 2007 Alert: Cannot login to database
J.C. Hornbeck
Hi everyone, Vikram Sahay here and I’m back again with another interesting topic on System Center Operations Manager 2007. Hope you find it useful. Recently we were working on an issue where we were getting an alert from few of the SQL servers as: 'Cannot login to database' We checked and verified...
on
20 Jul 2011
Blog Post:
System Center Operations Manager 2007 R2 now supports SQL Server 2008 SP2
J.C. Hornbeck
Quick heads up! The Supported Configurations Statement for OM2007R2 has been updated to support SQL Server 2008 SP2 . We now support the following roles on SQL Server SP2: Operations Manager database Data Warehouse database Audit Collections database ...read more
on
6 Jan 2011
Blog Post:
How to easily test your remote SQL connectivity
J.C. Hornbeck
Microsoft's own Steve Rachui explains how to quickly and easily test remote SQL connectivity using any account you like. This is a neat trick that will surely prove useful when working with a wide variety of products. J.C. Hornbeck | System Center Knowledge Engineer The App-V Team blog: http:/...
on
14 Dec 2010
Blog Post:
Solution: OpsMgr 2007 setup fails – cannot detect SQL
J.C. Hornbeck
The good folks over on the Operations Manager product team blog just posted a heads up on an issue you might run into where SCOM 2007 setup fails to detect SQL: If you have run into issues during setup where you know that you have a supported version of SQL running on your machine but setup in unable...
on
27 Oct 2010
Blog Post:
Trouble with setup due to SQL not being detected?
J.C. Hornbeck
If you have run into issues during setup where you know that you have a supported version of SQL running on your machine but setup in unable to detect it, you may have hit a SQL WMI provider issue. In OpsMgr 2007 R2, this shows up as the SQL Server requirement ...read more
on
26 Oct 2010
Blog Post:
OpsMgr 2007 Reporting does not support a SQL SRS Instance name with an underscore character in it
J.C. Hornbeck
Here's a quick note on an issue I saw recently. When you are trying to install Reporting for System Center Operations Manager 2007 (SCOM 2007), the installation wizard may hang after you select the SQL SRS Instance and click the Next button if the SQL SRS Instance name has an underscore ( _ ) character...
on
7 Oct 2010
Blog Post:
Overview of Opalis Integration Server connectivity requirements
J.C. Hornbeck
This article outlines the connectivity requirements for the various Opalis Integration Server components to interact with each other. If firewalls exist between the various components, rules may need to be introduced in your environment in order to allow the components to communicate. The core...
on
9 Aug 2010
Blog Post:
Is your Operations Manager console slow when editing groups? If so here's a tip to get you back in the fast lane
J.C. Hornbeck
Is your System Center Operations Manager 2007 admin console slow when editing groups? If so, you ought to take a close look at the membership rules, especially if you are using complex regular expression substring searches like below… Searches like this will result in a very heavy SQL load that...
on
29 Jun 2010
Blog Post:
Error with SRSUpgradeTool.exe /PostUpgrade when attempting to upgrade an OpsMgr R2 SQL 2005 Reporting Server installation to SQL 2008
J.C. Hornbeck
When following the steps of this article, http://technet.microsoft.com/en-us/library/dd789004.aspx , in order to upgrade your SQL reporting server from SQL 2005 to SQL 2008, you may encounter the problem described below. In step 4 you run SRSUpgradeTool /PostSQLUpgrade and receive the following error...
on
13 Aug 2009
Blog Post:
One new System Center Operations Manager 2007 KB article for the week ending 07/04/2009
J.C. Hornbeck
We just published a new Microsoft System Center Operations Manager 2007 article which addresses an issue where scheduled reports that you create by using SQL Server 2008 Reporting Services (SSRS) do not display chart data in Microsoft System Center Operations Manager 2007 R2: KB972821 - Scheduled reports...
on
6 Jul 2009
Blog Post:
Troubleshooting the import failure of the Active Directory 2008 Management Pack for MOM 2005
J.C. Hornbeck
Here’s an issue I ran into when I was trying to import the Active Directory 2008 Management pack for MOM 2005 SP1, and since I didn’t see it documented anywhere I thought I’d post it here. I was trying to Import the Active Directory 2008 Management pack for MOM 2005 and it was failing with the following...
on
25 Jun 2009
Blog Post:
Steve Rachui is an OpsMgr blogging machine
J.C. Hornbeck
If you’ve been reading this blog for any length of time then you’re already familiar with the postings made by Steve Rachui over on his Manageability blog, but there’s been a flurry of activity over there in the past two days and it probably deserves a quick pointer here just in case you’re not a subscriber...
on
10 Jun 2009
Blog Post:
OpsMgr 2007 R2 intros two new complex deployment scenarios not previously supported
J.C. Hornbeck
The System Center Operations Manager 2007 product team just announced the introduction of two new complex deployment scenarios we did not support in OpsMgr 2007 SP1: Clustering the RMS: In OpsMgr 2007 SP1, clustering a Root Management Server (RMS) was only supported during the initial deployment...
on
9 Jun 2009
Blog Post:
OpsMgr DB Grooming – How it works
J.C. Hornbeck
Steve Rachui just posted a great article on how grooming works in System Center Operations Manager 2007, so if you missed this and was ever curious how all this came together then you’ll definitely want to check this out. I have his intro and a link below: ======== A while back I wrote up a blog...
on
2 Jun 2009
Blog Post:
MOM 2005 ReliabilityAnalysisReporting task taking a long time to complete?
J.C. Hornbeck
If you have installed the MOM 2005 Reliability Analysis Reporting pack and found over time the task has taken longer and longer to complete, then it may be time to groom some of the older data from the database. The pack does have a grooming stored procedure built in, but it does not run automatically...
on
2 Jun 2009
Blog Post:
OpsMgr 2007: The SQL Server Management Pack has been updated to version 6.0.6569.0
J.C. Hornbeck
This may be old news to some of you but the Operations Manager product team recently updated the SQL Server Management Pack to version 6.0.6569.0. I included some of their additions below but you can read their original post here . The OpsMgr team is glad to announce that the most recent update...
on
7 Apr 2009
Blog Post:
OpsMgr 2007: Task results may return unformatted XML
J.C. Hornbeck
When running one of the tasks in the action pane of System Center Operations Manager 2007, the results may be displayed in a window as unformatted XML. This is due to a SQL transform that was added in the RTM (original) version and was changed with Service Pack 1. If you install a slipstream version...
on
19 Feb 2009
Blog Post:
The database discovery scripts (DiscoverSQL200*DB.vbs) fail on SQL servers with DBs larger than 32GB in the 6.0.6441.0 version of the SQL MP
J.C. Hornbeck
In case you missed it, The MOM team announced a new issue they've discovered. Apparently the database discovery scripts can fail on a system that has a DB that is larger than 32GB. I posted the description of the issue and a link below: ======== Issue: We've recently become aware of an issue with...
on
14 Nov 2008
Blog Post:
OpsMgr 2007: The Management Pack for SQL Server has been updated - now supports SQL 2008
J.C. Hornbeck
The Operations Manager Team Blog just announced that version 6.0.6441.0 of the SQL Management Pack has released. It offers support for SQL Server 2008 and much much more. I have an excerpt below but you can read the entire post here . ======= The OpsMgr 2007 management pack for SQL Server...
on
30 Oct 2008
Page 1 of 1 (21 items)