COMPUTER THREATS SECURITY
WHAT IS A FIREWALL IN NETWORK SECURITY
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
1433
|
|
|
3389
|
|
|
143
|
|
|
389
|
Detailed explanation-1: -If enabled, the default instance of the SQL Server Database Engine listens on TCP port 1433. Named instances of the Database Engine and SQL Server Compact are configured for dynamic ports. This means they select an available port when the SQL Server service is started.
Detailed explanation-2: -Port 1433 for TCP is needed to connect to the SQL database instance. By default, SQL will attempt to use 1433. If that port is unavailable, it will automatically choose another port. If this is the case, that port will need to be opened through the firewall instead.
Detailed explanation-3: -By Default SQL Server uses TCP Port 1433 for communication with applications. If you are running an application that requires connectivity with the SQL Server, you must enable port 1433 for SQL Server to listen on.
Detailed explanation-4: -Port 1433 was enabled (open) by default in previous versions of MS-SQL server, but as part of a hardening procedure implemented to improve the security of the MS-SQL server, port 1433 is disabled in current versions of MS-SQL Server.