SQL Service Accounts help

[Solarion]

I need your expertise please guys. Haven't done this is a very long time. I'm installing SQL on my home PC. Are these settings correct? TIA

 

[DominionZA]

On my dev machine, with the SQL 2014 Developer edition, I leave defaults and select Use Current User where no defaults.
Logged in with admin account.

 

[Solarion]

Alright thanks Mike. I'll just leave it as it is and see what happens.

 

[Nerfherder]

create a local admin and use that.

Disable RD logon for that admin

 

[Solarion]

create a local admin and use that.

Disable RD logon for that admin

Done. I've quickly created a test database and an SSRS report and everything seems to be running ok.

 

[JFT96]

For what its worth, in a test environment / home / non-production it perfectly ok to use SYSTEM auth. Everything will work perfectly.

For production environments, you would create a separate windows authentication account for each service - Engine, SSRS, SSAS and SSIS, SQL agent. Those accounts, whether AD or local should NOT have admin credentials. Any permissions to specific folders etc should be made for each windows auth account individually.

 

[Solarion]

Thanks JFT96. Noted for future.