Clustering and Binary Collation

  • I am trying to create a four node cluster.  One of my instances has a Binary sort order.  The SQL Server cluster install and SP4 worked.   Now I am trying to add additional drives for SQL Server to use.  I am able to do this for my case insensitive instances, and those SQL Server instances can see the drives. 

    On the Binary instance, once I add the drive and try to bring the instance back online, SQL Server will not come back up.  In cluster manager, the status just says "Online Pending". 

    If I go to the services applet and try to start it, I get a message the the service started and stopped.  The instance will failover to another node.  The error log actually looks like SQL Server is still running, and I can see sqlservr.exe in Task Manager.  I can also connect to it using Query Analyzer.  When I run this: "select * from ::fn_servershareddrives()", the correct drive letters show up in the results.  From Enterprise Manager, It looks like the instance is stopped.  I can also navigate to the drive.

    Has anyone successfully clustered a case sensitive instance?  What could I be doing wrong?

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • Never mind, another ID10T error.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

Viewing 2 posts - 1 through 1 (of 1 total)

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