When providing service accounts and passwords you might encounter one of the following error messages, which prevents you from continuing the installation:
- The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.
- The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service.
Solution: you may select NT AUTHORITY\SYSTEM and proceed. Later you can change the SQL service account with a dedicated domain service account meant for starting the service.
you can also provide the account with specific roles, like local admin, domain user/ admin based on org. and application specific requirement.
Recommendation:
Automatic restart of Service Accounts
Always make sure that if you are using domain account for running the SQL service, that account needs to be part of following 3 main resultant policies (you might have to do this from AD Group Policy to automatically reflect to the joined servers):
i) Log on as a batch job
ii) Log on as a service
iii) Act as part of the operating system
This will make sure that the account with which the SQL services run are automatically started after each system reboot.
1 comments:
Tried this it didn't work, anyway I found out after installing SQL Server core into Windows Server Core that you must have a complex password and make it longer e.g. I used Pa$$w0rd, didn't work, used Pa$$w0rd123 worked magically...hope this helps...thanks...
Post a Comment