You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 computer named Certkiller -DB01. You need to configure Certkiller -DB01 to use TCP/IP with all default settings. A Domain.com employee named Rory Allen works in the Finance department. Domain.com policy requires that every server make use of a firewall. You inform Rory Allen that you are able to connect to the SQL Server instance from the local workstation. However, the client computers are unable to connect to the SQL Server instance. Rory Allen needs to identify the most likely cause of the connection issues.
What should he do?
A.
Rory Allen needs to make sure that all client computers connect by using Shared Memory protocol.
B.
It is important that the server is not stopped.
C.
It is important that Rory Allen make sure that port 1433 is open in your firewall.
D.
Rory Allen needs to make sure that port 443 is open in your firewall.
E.
Rory Allen needs to make sure that all client computers connect by using the Virtual Interface Protocol.
Explanation:
The default instance of the Database Engine makes use of port 1433, but that can be changed. Instances of SQL Server 2005 Express Edition, SQL Server Mobile and named instances of the Database Engine make use of dynamic ports. The SQL Server Browser service lets users connect to instances of the Database Engine that are not listening on port 1433, without knowing the port number. In order to make use of the SQL Server Browser you need to open UDP port 1434.