Making SA Work

  • Vasant Raj

    SSCommitted

    Points: 1835

    Comments posted here are about the content posted at temp

  • SA-1

    SSCrazy Eights

    Points: 8113

    In SQL 2005, you can also rename the 'sa' account. So if you renamed it to, say 'ss2k5guru', and someone tried to login as 'sa' they would receive the error that the login failed and not that there is no 'sa' account.

  • bijulsoni

    SSC Journeyman

    Points: 98

    good Article very well explaining pls keep it up

    Your well wisher

  • ruchika thapa

    Ten Centuries

    Points: 1356

    what about the password after enabling the "sa" accout.

    Can we just go to SECURITY>LOGIN>RIGHT CLICK ON SA > ENTER NEW PASSWORD THERE AND CLICK OK?

    When i intalled SQL server it was in windows authentication so i don't remember if i have given any password to "sa" account myself..so can i just give password after enabling the "sa" account.

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

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