Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ASG RD 2018 database encryption question
#1
Hello, my company SQL team is asking me to improve security on SQL server.
Could help to answer if these improvement is OK or not?
Environment:
1. ASG RD 2018 on client PC
2. SQL server 13.0.5102.14 (I just got an instance from SQL team, I didn't have a whole server)

Question from SQL team:
TLS Encyrption:
Yes, enable
No, disable
Contact me for support

Remote Access
Enable
Disable
Contact me for support

   
Reply
#2
TLS ok (need TLS support on client and server side) - and how to access the database without Remote Access????
Regards/Gruss
Oliver
Reply
#3
Hello, Oliver, feedback on remote access:

Information about Remote Access
Remote access feature controls the execution of locally stored procedures on remote servers or remotely stored procedures on local servers.

This functionality can be abused by launch a Denial-of-Service (DoS) attack on databases by off-loading query processing to an external target.

Therefore we need to disable remote access configuration.

Note: This parameter does not apply to SQL Server Management Studio connections, if the parameter is disabled you will be able to connect to your database using SQL Server Management Studio.

More information in Microsoft webpage. https://docs.microsoft.com/en-us/sql/dat...rver-ver15
Reply
#4
We use only StoredProc when Database is created - direct SQL commands only when creating a database or when using Eval-version
Regards/Gruss
Oliver
Reply
#5
(23-07-2021, 08:15 AM)DevOma Wrote: We use only StoredProc when Database is created - direct SQL commands only when creating a database or when using Eval-version

So I can allow SQL team to disable "Remote Access"?
Thanks.
Reply
#6
It should work!
Regards/Gruss
Oliver
Reply




Users browsing this thread: 1 Guest(s)