Hi Jack,

Thanks for the reply. I wish it was that simple, I did think of that and changed the authentication method to a sql login. I probably should...

Well,

if anyone ever comes across this post I thought it best I put the solution in here.

The issue was a ridiculous one. In the planning and setup of this...

Jacob,

They're going to think we're the same person...we linked the same article and signed off with the same salutation!

Cheers indeed!

Wow! busy couple weeks, are you still availabe to assist me with this Perry?

I'm still having the same issues.

Let me know and I'll provide you with what you need.

Thanks!

Ah the HA index rebuild, I've just had to deal with this same situation. I found this article pretty helpful in determining my action plan for the work:

The bottom...

Hi Perry,

I've had few production issues come up in the past few days; I'll get that report off to you as soon as I can.

Thanks again!

You don't need a third server; but you do need some sort of quorum for automatic failover. A fileshare witness is probably the cheapest option. It will, of...

Well, this is turning out to be a rather interesting chain. If your server is spiked at 100/100; your issue probably isn't resources...Have a look at the indexes, are...

Hi Perry,

SQL Log is attached to the original post; I will gather up the other reports and logs you requested when I have a few minutes today.

To answer some of...

Hello,

I really appreciate the reply, thanks. Unfortunately I have checked all that; The cluster service is running under the local service account, but I have triple checked it has...

Well it's going to depend on what steps you used to bring it down. You had a few interesting replies. Did you implement anything that was discussed?

If you've...

Hello,

It would appear you have a collation mismatch in there somewhere. Have a look at the collation of the server you're using as well as the file.

https://technet.microsoft.com/en-us/library/ms175194(v=sql.105).aspx

If it's temporary; you can just disable the associated SQL agent jobs. Then adjust the schedule so they run at a time when the server is not under load.

Microsoft licensing will allow you to install a passive failover node with...

I would lean heavily towards a security issue. When you manually kick off a job it runs under the context of whatever you are logged in as. When...