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.
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...
ReplyDelete