SQL 2008 Cluster Sharepoint backend

Posted on 2011-05-05
Last Modified: 2012-05-11
We have a SQL 2008 cluster that appears to be broken.  There is a virtual instance (vsqlspntdb1) and 2 physcial nodes (sqlspnt01, sqlspnt02) Sqlspnt02 is the "owner" of the cluster but it should be the vsqlspntdb1.  
When I right click on a node, I don't see any option to move the resource to another node.  I'm unable to create a new maintenance plan or modify an existing plan - BUT the existing maintenance plan appeared to have run.  Haven't been able to verify because I can't remember where we're backing up to and I can't open the maintenance plan to verify/modify it.
Question by:skbarnard
    LVL 4

    Expert Comment

    Are you able to connect to the SQL Server Instance from management studio?

    What is the errors you see when you mentioned - the sql cluster appears broken and unable to edit maintenance plan?


    Accepted Solution

    Yes, I can connect but normaily one would see a green right facing arrow on both the instance and the agent, I see only a white circle.
    When I right click the existing maintenance plan and choose "modify", a window should open.  No window opens, no error shows up.
    A real funny thing, I can log into one physical server and the virtual but if I try to log into the last server in the cluster, I get kicked off of the virutual.  
    I don't know if that information is helpful, it's quite a curiosity for me.

    Author Closing Comment

    Turns out we called Microsoft for this issue and found if we used the "run as" administrator option, we could alter existing or create new maintenance plans.  It appears we may still have to rebuild our SQL cluster but for now, this issue was resolved.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now