Hello,
Our main concern is hacker.
I understand there are many access control mechanisms within MS SQL to control user access.
Bur what if a hacker somehow figured out the sa credentials, or otherwise gained access to the file system of the server from the public web portal on the Internet ?
None of these will likely happen with a MS SQL housed behind a firewall on a LAN with local access only.
Worldwide accessibility is a very desirable feature but need to consider the risk first.
Are our worries warranted ?
Comments and suggestions appreciated.
Our main concern is hacker.
I understand there are many access control mechanisms within MS SQL to control user access.
Bur what if a hacker somehow figured out the sa credentials, or otherwise gained access to the file system of the server from the public web portal on the Internet ?
None of these will likely happen with a MS SQL housed behind a firewall on a LAN with local access only.
Worldwide accessibility is a very desirable feature but need to consider the risk first.
Are our worries warranted ?
Comments and suggestions appreciated.