case no. [REG:112052135572244] Data Sync issue

Question

i have earlier posted that we are getting issue while synchronizing our SQL on premise table to SQL Azure with a recordcount of around 1 million.

Sync failed with the exception "GetStatus failed with exception:
SqlException Error Code: -2146232060 - SqlError Number:20, Message: The instance of SQL Server you attempted to connect to does not support encryption. "For more information, provide tracing id ‘7ba9caff-c9d5-44c3-8f85-32e5ba0f9adb’ to customer support.

please provide support since it is critical for us .

 

Answer 1

Hi nitinpuri,

Please see this thread: http://social.msdn.microsoft.com/forums/en/ssdsgetstarted/thread/e7cbe094-5b55-4b4a-8975-162d899f1d52?localeName=nb-no

As ahs101 said: So far we know it is an intermittent occurrence. For your reference Sql Azure always enforces encryption. [Update] It turns out that if during an early phase of the login process (before authentication) there is a failure, the protocol libraries (client side) will fall back to this error message. It can be a misleading message, especially since in the SQL Azure case, it is not encryption related. Please continue using the Encrypt=yes on your connection string setting.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.