Rory's profileSystem Center TrainingPhotosBlogListsMore Tools Help

Blog


    June 24

    OLE DB Monitors on Non-Default Ports

    OLE 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”

    unspecified error - OLEDB

    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.

    unspecified error - OLEDB-after

    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 2008

    So 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 Guides

    Ops 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 4000

    SNMP 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 Update

    OpsMgr 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.

     CWL-50028

     

    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