Announcement

Collapse
No announcement yet.

user for sql 2008

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • user for sql 2008

    hi all
    I'm installing sql2008 enterprise for traing.
    and my qustion is:
    Where do I have to build the sql user (sa)?
    As local or in the AD?

    thanks

  • #2
    Re: user for sql 2008

    sa is a local account within the SQL server and is only available if you selected mixed mode authentication when you installed the instance
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: user for sql 2008

      sa is a SQL account and neither local or domain.

      Ste
      Steven Roberts
      IT Mercenary

      MCITP:EA|MCTS|MCSE 2003 (Messaging and Security)|MCSA 2003 (Messaging and Security)|MCP|Prince2 Practitioner

      Don't forget to click on the Yin-Yang icon to leave reputation points if you think my advice has been worthwhile!

      Comment

      Working...
      X