Someone from your organisation is complaining that they can't connect to the HR SQL Server using SQL Management Studio. However, they can open the Management Studio ok and other people can connect…

The correct answer is A. The SQL Agent is not running. The SQL Agent must be running on the users machine to connect to an instance of SQL Server. This is a local service, which can be configured to start automatically. If it has stopped, just start the service from the Control Panel - Services console.

Design and implement an optimized monitoring strategy

Question

Someone from your organisation is complaining that they can't connect to the HR SQL Server using SQL Management Studio. However, they can open the Management Studio ok and other people can connect to the server fine. What might be the problem?

Options

AThe SQL Agent is not running
BSQL Client tools have not been installed on the users machine
CThe main server is probably down and needs rebooting
DNone of these

How the community answered

(30 responses)

A
80% (24)
B
10% (3)
C
7% (2)
D
3% (1)

Explanation

The SQL Agent must be running on the users machine to connect to an instance of SQL Server. This is a local service, which can be configured to start automatically. If it has stopped, just start the service from the Control Panel - Services console.

Topics

#SQL connectivity#SQL Server Agent#connection troubleshooting

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice