MSSQL Error – Access to the remote server is denied because the current security context is not trusted

When trying to load data from  database that is in AlwaysOn High Availability Group from Microsoft Excel the following error occurs:

Access to the remote server is denied because the current security context is not trusted

Make sure you have configured your connection with these three steps:

• Install the latest MS OLEDB Driver from Microsoft:

https://www.microsoft.com/en-us/download/details.aspx?id=56730

• In connection string make sure you have:

Provider=MSOLEDBSQL.1

MultisubnetFailover=True

• If the database’s content is not trusted by MS SQL server execute the following statement: