April 15, 2006 at 4:57 pm
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
April 15, 2006 at 7:37 pm
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