Question

alina is preparing to scan a microsoft sql server database server for open ports. what port should she expect to find supporting the database service?

Answer 1

Alina should use Port 1433 port. It is the only port that is open on the desktop computer and hosts the Database client application.

Step-by-step explanation:

Port 1433 is the default port for the Database server. It is a socket number for SQL. Alina should use TCP 1433 to connect the database engine: SQL Server Management Studio to manage SQL Server instances across the internet.

Is it secure?

No port is secure. You have to make it secure by your restrictions on access to it.

Answer 2

Hi, you haven't provided the options to the question but I will give the answer and you can check with the options.

The answer is PORT 1433.

Step-by-step explanation:

Microsoft SQL servers store data in a table structure, this stored data is then organised into rows and columns within the table object. This servers can be used to store vast quantities of data that can be easily retrieved by using SQL statements.

SQL is useful for data administrator to manage and organize the data, however, the administrator must specify precisely what data they are searching for.

A port number is a way to identify a specific process to which an internet or other network message is to be forwarded when it arrives at a server. They include; TCP port 1433, TCP 1434, UDP 1434...

TCP port 1433 is the default port for SQL server. Port 1433 is the only port that must be open on the desktop computer that hosts the SQL database client application.

Therefore, Alina should expect to find PORT 1433 as the port that supports the Microsoft SQL server database.