Thank you for the feedback

In my case I do not have any shared storage, so i wonder if it would be the same problem.  I am running Windows 2012 R2,...

Thanks

Yes, since my FULL and DIFF backups must be on the primary anyway, I am planning to set the AG to Primary as the preferred backup and creating the jobs...

Thank you very much for the reply.

I do not have the exact parameter information, but we are using USER_DATABASES, 28 days retention, compression and a few other basic settings -...

I am currently writing something up and will post it once its done

Yes, thanks for the reply that was exactly what it was.  I will mark your reply as answer.

I had to replace the registry key like he mentions in the article...

Still no solution to the problem, but I did find out that some of my servers are not successfully registering the SPN.  Strangely the server that cannot open the error...

Quick question

I have installed both ODBC 13 and ODBC 17 drivers on the server.  Is there something I need to do after that to let SSMS know that I have...

Thank you very much for the information

As a crazy thought, what happens if you try opening the error log file outside of SQL?  With the new instance you can shut...

I have stopped researching why the MSDASQL provider does not work using the ODBC Driver 17 on two of my three servers at this point.  I just reverted the ODBC...

Also, I am looking into using SQL Native Client instead of ODBC, but for some reason it does not work.  I need to get this to work and then propose...

Thank you very much for the response
In this case its an SQL Linked Server connecting to an ODBC DSN that connects to a different SQL server.   
The...

I checked the MSDASQL.DLL Driver versions on both servers and they are exactly the same. 

There are MSDASQL.DLL files in both the (x86) and 64...

So I am OK with the XML issue, but I still have problems using a linked server with the ODBC Driver 17.  
Recap: When I create a linked server...

Thanks for the help on the XML datatype issue.

Any thoughts on why the Linked server would work for only about 10 minutes and quits when using the...

I think I understand why you were able to retrieve the XML column with the old ODBC driver, but not the newer drivers.

The old ODBC driver does not know about...