Hi,

I'm learning SQL from book 'Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases'. I had installed 4 instances, one default and 3 named instances, all with the default service account settings.
Then I had to install an instance for auditing. For that purpose I created a domain account and grant it 'log on as a service' in the related policy group. From then none of the SQL related  services start on the earlier installed instances. That is: NT service\MSSQLSERVER, NT service\SQLSERVERAGENT.
I'm pretty sure I had misconfigured something by accident, but I have no clue how to resolve the problem.
Thanks for your help in advance.

P.

First of all, no need to grant permissions in advance - Setup takes care of of that. Or SQL Server Configuration Manager if you change the service account later. (You should never change the service account from the Services applet.)

When you attempt to start the services, is there an error log created in the LOG directory for the instance? In such case, what error messages are there?

Have you checked the Windows event log for messages?

It would be better if you also share error you get when you try to start services. The error might give us clue. The error would be in event viewer

Erland is correct to say that when you start SQL Server with any account using SSCM it takes care of privil