Target Server Connection to (localDb)\v11.0 fails with "does not support encryption"

Oct 11, 2012 at 6:12 PM
Edited Oct 11, 2012 at 7:16 PM

Very smooth From (localDb)\v11.0 to Azure .... thank you!

But when I attempt to go from Azure to my localDb I get a

The instance of SQL Server you attempted to connect to does not support encryption

when I attempt to Connect to Server in the 'Setup Target Server Connection"

The script that was generated and saved worked perfectly when run manually against the localDb to generate the table schemas and I assume I can use Management Studio to now move the data... or not.

P:)

Coordinator
Oct 17, 2012 at 7:40 PM

Hi,

 

Can you edit SQLAzureMW.exe.config file and search for “ConnectionString”?  You will find two entries.  In both strings you will find “Encrypt=true;”.  Can you remove that and then try again?  Let me know if that does not work.

 

Thanks,

George

 


Oct 17, 2012 at 8:24 PM

Works like a charm ... soooo much nicer than Management Studio.

thank you!