Re: SQL 6.5 sa Password, how to change?

From: PBS (pbs_at_allwave.com)
Date: 02/04/04

  • Next message: AL: "Restrict remote admin" 
    Date: Wed, 4 Feb 2004 14:43:09 -0700

    Russell and others:

    Thanks for your responses.

    OK, for the sake of argument, "theoretically speaking", let's just pretend
    that the mess I am trying to clean up has an application running as "sa".
    What do I replace that with? do I create a new NT User?, or is there a
    place to create SQL users?

    Thanks again
    Paul

    "Russell Fields" <RussellFields@NoMailPlease.Com> wrote in message
    news:e%23Djpqz6DHA.2712@tk2msftngp13.phx.gbl...
    > Paul,
    >
    > Use sp_password to change it. Make it a strong password. Here is
    > Microsoft's simple definition of strong:
    >
    > Security Note Use strong passwords. A strong password makes it more
    > difficult for unauthorized users to break into a system by cracking the
    > password. A strong password is at least seven characters long; contains a
    > combination of letters, numbers, and symbol characters within the
    password;
    > and is not a dictionary word, command name, person's name, or system user
    > name. A strong password also is updated regularly and is significantly
    > different from previous passwords.
    >
    > And never, never, never have an application run as sa. (This will slightly
    > limit what the application can do.) Always run as a user with appropriate
    > rights granted.
    >
    > Russell Fields
    > "PBS" <pbs@allwave.com> wrote in message
    > news:ONAHHaz6DHA.2064@TK2MSFTNGP11.phx.gbl...
    > > Hello:
    > >
    > > What is the procedure for changing the sa password in SQL 6.5?
    > >
    > > Thanks
    > > Paul
    > >
    > >
    >
    >

  • Next message: AL: "Restrict remote admin"