May 25, 2018 at 6:32 am
HI,
Inherited some DB's with 'allow remote connections'.
Company does not use a VPN, We use an RDP gateway to access from home.
I know allowing remote access is a security risk, but would I still be able to remote in without it enabled?
May 25, 2018 at 8:32 am
Do you mean the server level "remote access" setting or the "allow remote connections" setting for the service? "allow remote connections" has to be on in order for you to access the SQL Server from a machine other than the one hosting the SQL Server and is set using SQL Server Configuration Manager.. "remote access" is a deprecated setting that you should be able to turn off, but really doesn't do any harm if left on and not used.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 25, 2018 at 8:39 am
krypto69 - Friday, May 25, 2018 6:32 AMHI,Inherited some DB's with 'allow remote connections'.
Company does not use a VPN, We use an RDP gateway to access from home.
I know allowing remote access is a security risk, but would I still be able to remote in without it enabled?
Yes you'd still be able to remote in. That option is deprecated anyway - refer to this article:
Configure the remote access Server Configuration Option
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply