MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. You need to ensure that the instance is configured to allow remote connections even if SQL Server is unresponsive to client connections. What should you do? Choose all that apply.
A
Enable inbound connections on TCP port 1434 in the firewall on the server
B
Execute the following T-SQL command:sp ____ configure ‘remote admin connections’
C
Restart the SQL Server Agent Service
D
Enable inbound connections on TCP por 135 in the Windows Firewall on the server.
Explanation: 

Detailed explanation-1: -In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Select Next. In the Action dialog box, select Allow the connection, and then select Next.

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.

Detailed explanation-3: -On the local machine, click the Start button and enter “CMD” in the search programs and files field. If the port 1433 is closed, an error will be returned immediately. If the port 1433 is open, you will be able to connect to the MS-SQL server.

There is 1 question to complete.
Previous
Next