Today, while trying to generate a new WCF-SQL Schema from Visual Studio, we got the following error:
Connecting to the LOB system has failed.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.).
Cause
That error occurred because we had previously tried to generate an SQL schema connecting to an Azure SQL Database, and for that, we needed to set the Encrypt property to true.
- Encrypt property specifies whether SQL Server (with a valid certificate installed) uses SSL encryption for all data transfers between SQL Server and the client. The default value is false.
Why am I referring to this? The Consume Adapter Service wizard tool caches the settings that you have set up on the previous execution, except if this is the first time you have executed the tool since you opened the Visual Studio Project. That means:
- When you open the Visual Studio project, the first time you execute the Consume Adapter Service wizard tool, it has the default settings.
- While staying with that Visual Studio instance open. In previous runs of the tool, you see the previous settings configurations, except for the passwords.
- If you close Visual Studio, those settings are “clean”.
In our case, we were trying to connect to a local database, which doesn’t use certificates, so the Encrypt setting needs to be turned off.
Solution
The solution to this problem is quite simple but not easy to understand, given the error information and the Visual Studio behavior of caching settings.
- On the Consume Adapter Service wizard tool, click on Configure.
- On the Configure Adapter window, click on the Binding Properties tab and set the Excrypt property to False.
After that, we were, once again, able to successfully connect to SQL Server.
Hope you find this helpful! So, if you liked the content or found it useful and want to help me write more, you can buy (or help me buy) my son a Star Wars Lego!
