Failover Cluster Management + SQL Server 2008 Cluster
HELP.. I am trying to configure our 2008 Failover cluster with SQL Server 2008. I am BRAND SPANKING new to clustering. I installed MSCS fine and tested and everything was working spectacular. THEN I installed MSDTC and MSDTC server will not start.
Problem # 1 - MSDTC server will not start, states that the network name is the problem. I used the default network name, is there something more I need to do?
So in my attempt to mess things up even more... I decided to install SQL Server 2008 (clustering) since the pre-req check stated MSDTC does not have to be installed at the time of SQL Server 2008 (clustering) install. Went through everything and now SQL Server 2008 states that it installed however there were errors in starting it up. And again per the dependency report, it seems to be with the network name.
Problem #2 - SQL Server 2008 Cluster will not start, states the network name is the problem.
An associate mentioned in previous versions one had to add the MSDTC network to the Cluster networks, however I do not see any way to do this. I am assuming that may be the issue with SQL Server as well, but we all know what happens when we assume.
Any and ALL advice would be greatly appreciated ASAP.
Problem # 1 - MSDTC server will not start, states that the network name is the problem. I used the default network name, is there something more I need to do?
So in my attempt to mess things up even more... I decided to install SQL Server 2008 (clustering) since the pre-req check stated MSDTC does not have to be installed at the time of SQL Server 2008 (clustering) install. Went through everything and now SQL Server 2008 states that it installed however there were errors in starting it up. And again per the dependency report, it seems to be with the network name.
Problem #2 - SQL Server 2008 Cluster will not start, states the network name is the problem.
An associate mentioned in previous versions one had to add the MSDTC network to the Cluster networks, however I do not see any way to do this. I am assuming that may be the issue with SQL Server as well, but we all know what happens when we assume.
Any and ALL advice would be greatly appreciated ASAP.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check the event logs/ cluster logs to see what may be going on with the DTC. I'm suspecting it may have something to do with the kerberos from my experiences with setup. I had similar issues initially. Also did the cluster validation pass ?
ASKER
Upps.. I take that back. I deleted the DTC object that was automatically created by MSCS and then created my own DTC object! We are a go! YES! I will finish up with Node 2 and report back with points or issues. Thank you soooo much!
ASKER
No, I did not pre-stage the computer object, was that in the Microsoft instructions? I did not see that step. Each physical node is added to the domain. I did not perform #2, however the object was created and placed in the default computers container by MSCS. I have a security group acct created and added both physical nodes, the MSCS cluster object, SQL cluster object and added the DTC object as well.
Bounced nodes and SQL Server Cluster is now enabled (YAY!!!) however of course...DTC is still down and will not come online.
<BIG SIGH>