check the windows event log and the cluster events too

johnnyrmtl (1/21/2015)

---

Thanks for the reply...and sorry for the confusion.

I need to propose a 2 server clustering / failover solution with SQL 2012 and it seems that the log shipping feature...

if you're getting a timeout sounds like either a firewall or issue in the networking stack. Is the cluster validation report completely clean?

virgo (1/16/2015)

---

Hi...

Can any one help me with steps and methods for automating the sql server cluster installation with out using the GUI. Can we have a config file or scripts...

not sure I'm clear on what you're asking, could you explain a little more please, what are you trying to achieve?

its perfectly valid to have instances with different patch levels, this is one of the main reasons why you would ring fence a particular apps database to a separate instance

you may have a windows server failover cluster that employs physical and virtual nodes

snomadj (1/16/2015)

---

does anybody know at what level it checks connectivity to the P & M?

is it pinging / checking access to the database / checking at the app level? ...

what are you referring to as Pand M

First question is why?

You're taking the decision to implement an AlwaysOn group...

be aware that when you enable a read only secondary in an AlwaysOn group, all isolation levels are automatically...

ramyours2003 (1/18/2015)

---

I have 10 databases which are configured as principal in mirroring I need to failover all the databases as part of failover , instead of writing query each database...

have you checked the setup log?

sounds like its been uninstalled, what do you see in sql server configuration manager on the node itself