Last Friday I received an email with the subject “default installation guidelines”. In the body it wrote:
What do i set for service accounts and collation settings?
Perfect opportunity for a starting DBA to shed some newly learnt knowledge. With the current guidelines in mind and my input from what I’ve read, we agreed to this:
- Collation: we will continue to use the collation as per the checklist to maintain consistency among ALL SQL Servers.
- Service Accounts: we will create domain accounts for each SQL Server service being installed.
If you have any suggestions or feedback on this or would like to share your guidelines on collation and service accounts feel free to comment.
Advertisement
