Cluster missing SQL Server Resources

  • Hi,

    We have a winwos cluster setup but none of the SQL Server Resources show up under Resources.

    We can't re-install SQL Server because the instance is currently in use.

    We're using SQL Server 2005 Standard on a MS Windows 2003 Enterpriser x64 server.

    Any suggestions?

  • you've posted in a sql7- sql2000 forum ??

    - are you using the correct cluster server ?

    double check you opened clusteradmin to the correct cluster configuration (perferably "." (i.e. local)) at one of the nodes)

    - Can it be you installed your sql2005 instance as a local named instance on one of the cluster nodes ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • I also see sql server resource and sql server agent resource is missing in cluster administrator in one of my instance. Is there any way to recover them. Probably it is some thing to do with the registry in windows 2003. Can somebody provide me with any related link.

    Thanks,

    Hidayath-MS SQL Server DBA

  • hidayath_be (11/8/2010)


    I also see sql server resource and sql server agent resource is missing in cluster administrator in one of my instance. Is there any way to recover them. Probably it is some thing to do with the registry in windows 2003. Can somebody provide me with any related link.

    Thanks,

    Hidayath-MS SQL Server DBA

    This is an old thread, please start a new one !

    Did you provide this node (having items missing) already pointed for failover node ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • yes that works

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply