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 likel

Question

Options

• AThe SQL Server codes are performing badly.
• BThe SQL Server has not been tested properly.
• CThe SQL Server ports to the main machine are closed.
• DThe SQL Server has many concurrent users.

• B
  5% (2)
• C
  93% (40)
• D
  2% (1)

Explanation

When a user's credentials are set up correctly but they cannot connect from a specific workstation, the most likely cause is that the network port used by SQL Server is blocked between the workstation and the server (option C). SQL Server listens on TCP port 1433 by default. If the firewall on the server, the network firewall, or the client's firewall blocks this port, no connection can be established regardless of credential correctness. This is especially common in new setups where firewall rules have not been configured for the new user's machine. Option A (poor-performing queries) would affect speed, not connectivity. Option B (insufficient testing) is vague and not a root cause. Option D (many concurrent users) could cause slowness or refusal under connection limits but is unlikely to block a single new user entirely.

No community discussion yet for this question.