Yes I did and I asked a co-worker to respond as he will be taking over this functin in our shop...I am retiring in two weeks and thought it would...

Wilbur...

I tried creating the proxy account on the destination server and lo and behold it all worked...Thanks very much

Tell Mr. Ed I said Hello Wilbur...

I was pretty sure when I set up the source and destination connections I used windows authetication...I double checked and tha is what they are set to use...Thanks

Thanks for the quick response...I went ahead and and tested this in a new test environment that was set up for me just this morning...As far as the application we...

So one last question and I'll put this discussion to bed...

I will set up my WSFC to have 3 nodes Primary, Seconday and a file share each having one vote...

We...

The reason I did not give the DR site a vote was based on the following Microsoft Article

The Fileshare witness is located on the Primary Nodes Subnet

https://msdn.microsoft.com/en-us/library/hh270280(v=sql.110)

Recommended Adjustments...

OK I have read all the comments as well as read the Stairway series on AlwaysOn...

I am still unsure how to set up the QUorum???

Here is what I understand...(And this...

I am also using the performance counter Failed Jobs _Total and I see 3 jobs failed but when I check Activity Monitor I do not see any failed jobs for...

Thanks Wilbur...

I deided t use the "UserParameter= " approach and setup a query to Sql Server fom Zabbix and look at the result set and then trigger off that (i.e....

Thanks for the reply Kevin...Zabbix is big in the Linux world and we have about 50% Linux servers and 50% Windows...It is Open Source and works quite well but can...

Thanks...

I checked the both servers and sure nuff the secondary server had its firwall enabled whereas the primary server had its firewall disabled. I disabled the firewall on the secondary...

I have been at this for several days and have been able to complete the windows cluster. I have created an availability group with my two nodes. I have three...

Lynn Thanks for the quick response...

I have been experimenting with this approach. I do have one question.

If I had a table that had 10 million rows and I only...

I'm Sorry, I just re-read your first post and it clearly states only keep one copy of the tables...Brain freeze...

Thanks for the response. I went and did a little reading on SYNONYMS and I think I understand the idea. Since the application we are using is a COTS product...