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.

    Thanks
    James

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

    http://cryptome.org/nsa-w2k/nsa-w2k.htm

    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 www.microsoft.com/technet
    www.24y.co.uk - Fast Professional UK Web Hosting

  3. Newsletters

    Subscribe Now & Get The WHT Quick Start Guide!

Related Posts from theWHIR.com

Posting Permissions

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