How to secure the connection between FE and SQL Server? (1 Viewer)

npa3000

Member
Local time
Today, 20:15
Joined
Apr 16, 2021
Messages
36
Hello,

I managed to connect the SQL Server with the front end file but i am a bit concerned with the security of the connection. What can i do to ensure that the connection is encrypted and no one can access the data of SQL Server?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:15
Joined
Oct 29, 2018
Messages
21,358
You could use Windows Authentication as your login scheme.
 

sonic8

AWF VIP
Local time
Today, 19:15
Joined
Oct 27, 2015
Messages
998
What can i do to ensure that the connection is encrypted
Enable the "Force Encryption" setting in the Network Configuration of your server. I described this in more detail in How to Create and Install a Self-Signed SSL/TLS Certificate for SQL Server. For a production server you should use an "official" certificate and not a self-signed one, of course.

... and no one can access the data of SQL Server?
If you literally mean no one, then shut down the server and delete the data. ;-)
I guess that's not what you meant. Then the first step would be to think about who should access which data and who should not.
 

Users who are viewing this thread

Top Bottom