Guys, apologies in advance for posting this here also (posted on SSC as well) but since I've had no replies I thought I'd try my luck here...
Need to install SQL Server on a new box. OS installed and ready etc...
The server has two drives:
C - RAID 1 across two 46GB drives D - RAID 5 across 3 600GB drives
The new server is not in the trusted domain so can't use AD accounts.
See below of another server that was configured by someone else a few years back but I don't like the fact that the services are using the Administrator account?!
So my plan for the SQL Server installation is as follows:
1) Create new local accounts and let SQL Server assign the required permissions. 2) Ensure Anti-Virus software skips .MDF, .LDF and .NDF files 3) Enable Instant File Initialisation. 4) Use drive C for SQL Server installation and drive D for .MDF and .LDF files (including TempDB).