Post reply

sa password change, is it required with CHECK_POLICY=ON

  • June 14, 2010 at 4:43 am

    #1179748

    samiam914 (6/13/2010)

    Is it necessary for me to change the sa password?

    What sort of problems are expected if I do not change or do change.

    It is not necessary but recommended to change it , if you feel that some anonymous people know it (which shouldnt be) then you must change it

    secondly if wont effect anythiing unless you are using it at places where it is specified or hard coded.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • June 14, 2010 at 3:06 pm

    #1180122

    Thank You. Some what related question - if a windows ID (in sql server setup as windows authentication) has sysadmin authority and it is the owner of a database, when windows password changes, is there something that needs to be done in sql server. Database is not encrypted in this case.

  • June 14, 2010 at 11:01 pm

    #1180188

    samiam914 (6/14/2010)

    Is there something that needs to be done in sql server.

    NO

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • June 15, 2010 at 10:27 am

    #1180565

    Thank You.

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply