Results 1 to 2 of 2
  1. #1

    * MS SQL Setup Help Please

    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.


  2. #2
    Join Date
    Apr 2001
    UK - Liverpool
    i read this recently and thought it was great:

    its not SQL but it does give you some great tips about the Win2k side of your box.

    Check Microsofts wek site for the SQL security whitepaper - Fast Professional UK Web Hosting

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts