Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    79

    Unanswered: Some basic questions

    Hi

    A quick question:Can we disbale sa account in sql server 2000?

    Rgds

    Wilson

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    A quick answer: No

    BUT...

    Create another account and give it sa privileges...you're gonna need them...

    Then make a strong password for sa..place it in 2 sealed envolopes...

    Keep one locally and keep one off site and never use sa...

    (I should practice what I preach...)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    No. You can, and should, change the password to something so cryptic noboby will ever break it or want to use it. Throw that into a file in a directory with nobody but 2 people in the company having access and forget it exists until you change it again. Even with that level of protection, I like to change it on key personnel changes and quarterly.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Apr 2004
    Posts
    79
    Thanks for ur quick reply.

  5. #5
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    We can disable it by setting the authentication mode to Windows only, but this would disable all users using SQL-Authentication ; only the users with Windows-Authentication would be able to access SQL.

    Howdy!

Posting Permissions

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