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

mssql-error-access-to-the-remote-server-is-denied-because-the-current-security-context-is-not-trustedWhen 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:

 

 

 

 

Be sociable 🙂 Share!
error

Comments/Коментарі/Комментарии