I have been asked to set up a machine with Win2k and SQL2k for web hosting. I'm confident in my ability to set it up OK but I would be grateful for any pointers (from established web hosts?) on any particular SQL hosting issues or security issues (permissions)that I should be aware of at setup time.
Two issues that I've come up with so far are:
1. Authentication Mode. It appears that Windows Authentication is the most appropriate. Are there any gotchas in not using Mixed Authentication.
2. Service Account. There are two options; a local account or a system account. I would have thought the system account was the one to choose but I don't understand the difference in this context.
Any help gratefully appreciated.