Rory's profileSystem Center TrainingPhotosBlogListsMore ![]() | Help |
|
June 24 OLE DB Monitors on Non-Default PortsOLE DB Monitors on Non-Default Ports Have you ever wanted to monitor SQL availability using an OLE DB monitor in SCOM 2007 and run into the following error? “Unspecified error”
The resolution to this is to add the port number to the connection string. This isn’t possible however when you use the Simple Configuration option in the Add Monitoring Wizard but there is a very quick work around to this. Create the connection string using the Simple Configuration option and then change to Advaned Configuration and enter a comma and the port number after the SQL Server name or SQL Server\instance name.
So typically, your connection string will look something like this before adding the TCP Port: Provider=SQLOLEDB;Server=DWWPRPOLYSQL1P;Database=SCOMProdOpsDB;Integrated Security=SSPI
Modify this to include the TCP port as shown below: Provider=SQLOLEDB;Server=DWWPRPOLYSQL1P,1832;Database=SCOMProdOpsDB;Integrated Security=SSPI Voila, problem solved! You can now monitor databases in instances of SQL that use non-standard (TCP 1433) ports.
For this and more great information on Operations Manager 2007, check out our training at http://www.infrontconsulting.com/events.htm. June 16 Activating Windows Server 2008So today was the day to try replacing Vista on my notebook with Windows Server 2008 x64 and hyper-v in an effort to get better performance out of the notebook and the virtual machines that run on the notebook.
Two issues came up, the first is activation. Everytime I attempted to activate, I got the message: "Activation Error: Code 0x8007232b, DNS Name does not exist". The resolution to this is to run the following command where xxxxx-xxxxx is the VLK.
slmgr -ipk xxxxx-xxxxx-xxxxx-xxxxx-xxxxx
The second issue is connectivity to a projector. This was easily resolved when I downloaded and installed the latest Vista x64 video driver. Now my notebook running Windows Server 2008 x64 connects fabulously to my infocus in10 projector.
A great post on running Windows Server 2008 as your desktop can be found at http://weblogs.asp.net/israelio/archive/2008/02/21/windows-server-2008-as-workstation.aspx June 03 Ops Mgr MP GuidesOps Mgr MP Guides Are you looking for MP Guides? If so, check out http://technet.microsoft.com/en-us/library/cc540358(TechNet.10).aspx.
Looking for great Ops Mgr training, check out http://www.infrontconsulting.com/events.htm. SNMP and OpsMgr SP1 + Event ID 4000SNMP and OpsMgr SP1 + Event ID 4000 Are you working with Operations Manager 2007 SP1 and SNMP? Are you seeing Event ID 4000 from source Health Services? If so, take a look at KB951526.
Looking for great Ops Mgr training, check out http://www.infrontconsulting.com/events.htm. June 02 MOC 50028: System Center Operations Manager 2007 UpdateOpsMgr Courseware Library Update
Thinking about taking the Microsoft Official Curriculum (MOC) instructor led training for Operations Manager 2007, well first let’s be clear that this isn’t MOC, it’s a courseware library course (CWL) and it’s currently under review do to the feedback that it’s been receiving.
If you are looking for some excellent training on System Center Operations Manager 2007, check out www.infrontconsulting.com/events.htm. We run classes around the world, taught by consultants that have experience implementing the software and who have answers to your real world questions.
Rory |
|
|