Thank you. Im fairly positive it is not best practice 😉

More of a temporary solution immediately following the migration.

Thank you for the responses.

Ray,

That worked, thank you. I had tried setting the SQL Server service like this at first but did not set the Agent. After setting both to use the...

I have no issue with the failover of the DB. It is just the app I am tying to figure out.

My setup to make understanding easier....switch, 3 servers, 1...

Andrew,

I actually think you do understand my situation.

I was looking at NLB as well as Application Request Routing unless those are one in the same. I need to do...

Ok. Maybe I can put the webapp on the witness. Sorry, I am fairly new to the mirror/clustering business.

So if I wanted to just use LIV and MIR,...

But if the webapp is on "LIV", the connection string is on that server. So if that server goes down, so does the whole app. Isn't that right?

My...