LAST MONTH YOUR COMPANY WENT THROUGH AN EXERCISE TO STANDARDIZE SER...

2. Last month your company went through an exercise to standardize service

accounts while you were on holiday. You’ve just restarted SQL Server after

applying a service pack, and now the instance won’t start. You check the

Windows Event Log and see lots of errors about not being able to open the

error log. What is the most likely cause?

A. The SQL Server Service account was not changed using SQL Server

Configuration Manager

B. The service pack failed

C. Data corruption

D. You don’t have the right permissions to the error log

Correct Answer & Explanation: A. If you don’t use the Configuration

Manager tool to change the service account, it will not get explicit permis-

sions to the SQL Server directory structure. SQL Server will not start without

permissions to create an error log file.

Incorrect Answers & Explanations: B, C, D. Answer B is incorrect, although

technically feasible; the service pack should have generated errors if there was a

problem, and given the scenario it is not the most likely cause. Answer C is

incorrect, although technically feasible; given the lack of any other errors and

the scenario it is not the most likely cause. Answer D is incorrect because the

issue is with the Service Account permissions, not your account. To install the

service pack you would have needed full Administrator rights on the server

anyway.