# Sql Server encrypted connection

**URL:** <https://forums.toadworld.com/t/sql-server-encrypted-connection/32765>\
**Category:** Toad Data Modeler\
**Created:** [March 4, 2015, 8:17am UTC](https://forums.toadworld.com/t/sql-server-encrypted-connection/32765 "2015-03-04T08:17:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![anne.miller](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@anne.miller](https://forums.toadworld.com/u/anne.miller)\
**Post date:** [March 4, 2015, 8:17am UTC](https://forums.toadworld.com/t/sql-server-encrypted-connection/32765/1 "2015-03-04T08:17:50Z")

</div>

I don’t see a way to make a reverse engineering connection to SQL Server 2008r2 with an encrypted connection. Anybody got advice? We are moving the server to Sql Server 2012 soon if that makes any difference. We will have a server that requires encrypted connections. Thanks!

---

<div class="post-metadata">

**Author:** ![Lukas.Knapek](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/lukas.knapek/32/269_2.png) [@Lukas.Knapek](https://forums.toadworld.com/u/Lukas.Knapek)\
**Post date:** [March 5, 2015, 12:20am UTC](https://forums.toadworld.com/t/sql-server-encrypted-connection/32765/2 "2015-03-05T00:20:57Z")

</div>

Hello Anne,

There is currently no specific option for encrypted connections to SQL Server databases. We will look into this and see if we can come up with solution or workaround to your issue. In the meantime, thank you for reaching out.

Regards,

Lukas

---

<div class="post-metadata">

**Author:** ![Lukas.Knapek](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/lukas.knapek/32/269_2.png) [@Lukas.Knapek](https://forums.toadworld.com/u/Lukas.Knapek)\
**Post date:** [March 11, 2015, 2:57am UTC](https://forums.toadworld.com/t/sql-server-encrypted-connection/32765/3 "2015-03-11T02:57:28Z")

</div>

Hello Anne,

Could you tell us what happens exactly when you try to connect to your server via TDM? Does any error appear?

While **Native Connection** currently doesn’t support encrypted connection, you might want to try **Connection via ADO**.

Once you choose **Connection via ADO** in **Reverse Engineering Wizard,** choose **Data Link Properties | Build,** select a provider in **Provider Tab** (e.g. **Microsoft OLE DB Provider for SQL Server** ) and in **All Tab** look for property **Use Encryption for Data** or **Trust Server Certificate.** Set it to true and then fill in the rest of connection details.

![0160.datalink1.png](https://global.discourse-cdn.com/quest/original/2X/6/6d2499eb582c0949f27c1bb62f8ede347d499eb9.png)

![datalink2.png](https://global.discourse-cdn.com/quest/original/2X/a/a037749903d41b66a6193ad071721fbb0c961573.png)

Let us know if this method works for you.

Regards,

Lukas

---

<div class="post-metadata">

**Author:** ![anne.miller](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@anne.miller](https://forums.toadworld.com/u/anne.miller)\
**Post date:** [March 11, 2015, 7:45am UTC](https://forums.toadworld.com/t/sql-server-encrypted-connection/32765/4 "2015-03-11T07:45:22Z")

</div>

Thanks, Lukas! This works for connecting to Sql Server 2008 R2 with data encrypted !

---

<div class="post-metadata">

**Author:** ![Lukas.Knapek](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/lukas.knapek/32/269_2.png) [@Lukas.Knapek](https://forums.toadworld.com/u/Lukas.Knapek)\
**Post date:** [March 12, 2015, 3:53am UTC](https://forums.toadworld.com/t/sql-server-encrypted-connection/32765/5 "2015-03-12T03:53:27Z")

</div>

We have also learned that **Native Connection** should be encrypted and work with a SQL Server that **requires** encrypted connections. If a server **does not require** an encrypted connection, the **Native Connection** does not use it and there is currently no way to force it (but we plan to implement this option in future).

Basically, you should have no problems using Native Connection with your new SQL Server 2012 that requires encryption. But if you encounter any problems, please let us know.

Regards,

Lukas
