SQL Server Data Provider
Does RDM use the SQL Native client installed on the computer to connect to the sql server or does it have its own provider built in?
We have an ssl certificate installed on our sql server and force all clients when they connect to use it.
If RDM uses its own built in client, will it use the forced encrypted connection?
All Comments (5)
Hi,
We no longer use the SQL Native Client, we use the Microsoft SQL Provider from the .NET Framework and I'm pretty sure that you can specify the encrypted connection. I exposed that in the advanced settings of the data source. These options will build a connection string:
http://www.connectionstrings.com/sql-server-2008
I hope this help
David Hervieux
Devolutions inc.
David Hervieux
That my friend is exactly what I needed to know. Thank you.
I am experiencing an issue with sql data source advanced options.
I can set encrypt to true. I can set trust server certificate to true.
I cannot set them both at the same time. When I set the values for both and then save and return, the settings are wiped out. Do I need both? I do right?
The reason I need trust server certificate is because ther ssl cert is self signed.
Hi,
I verified and there was a save bug, can you try this version:
http://remotedesktopmanager.com/download/Setup.RemoteDesktopManager.5.8.3.3.exe
David Hervieux
The new version is working. Thank you for the quick fix.
I am liking this tool more and more as I use it.