Question
A database administrator set up a connection for a SQL Server instance for a new user, but the administrator is unable to connect using the user's workstation. Which of the following is the most likely cause of the issue?
- A. The SQL Server codes are performing badly.
- B. The SQL Server has not been tested properly.
- C. The SQL Server ports to the main machine are closed. Correct
- D. The SQL Server has many concurrent users.
Explanation
When a connection works on the server but fails from a client workstation, the most likely cause is that the firewall blocks the SQL Server port, by default TCP 1433 for the default instance (and UDP 1434 for the SQL Server Browser with named instances). Poorly performing code, insufficient testing or many concurrent users would slow the server down but would not stop a new client from connecting at all.
