Sql Server Password Expiration?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • mbailey

    Sql Server Password Expiration?

    This has to be a simple question for most of you, so here goes.

    My passwords for sa and another login that I created keep resetting.
    How can I turn off password expiration in SQL Server 2000?

    Thanks!
    MB

  • Simon Hayes

    #2
    Re: Sql Server Password Expiration?


    "mbailey" <matt.bailey@gm ail.com> wrote in message
    news:1119471139 .532067.262100@ g44g2000cwa.goo glegroups.com.. .[color=blue]
    > This has to be a simple question for most of you, so here goes.
    >
    > My passwords for sa and another login that I created keep resetting.
    > How can I turn off password expiration in SQL Server 2000?
    >
    > Thanks!
    > MB
    >[/color]

    As far as I know, there's no standard way to reset passwords in any version
    of MSSQL, because 'resetting' implies going back to a previous password, and
    unless you know the previous password that shouldn't be possible. Perhaps
    you can correlate the reset with an MSSQL or Windows scheduled task?
    Alternatively, you could consider Windows authentication instead; that's the
    MS recommendation, and it means you can use the same password policy defined
    in AD.

    If this isn't helpful, I suggest you give some more details about your
    servicepack level, how you know that a password has been reset, how often
    it's reset, if Profiler has shown any unusual activity etc.

    Simon


    Comment

    • Erland Sommarskog

      #3
      Re: Sql Server Password Expiration?

      mbailey (matt.bailey@gm ail.com) writes:[color=blue]
      > This has to be a simple question for most of you, so here goes.
      >
      > My passwords for sa and another login that I created keep resetting.
      > How can I turn off password expiration in SQL Server 2000?[/color]

      You find that other person who is changing the passwords and slap
      him on the fingers.

      That is, there is no password expiration in SQL 2000. (There is in
      SQL 2005, if you run on Windows 2003, although I think it is off
      by default.)


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server SP3 at
      SQL Server 2025 redefines what's possible for enterprise data. With developer-first features and integration with analytics and AI models, SQL Server 2025 accelerates AI innovation using the data you already have.

      Comment

      • mbailey

        #4
        Re: Sql Server Password Expiration?

        Simon and Erland, thank you for your replies.

        What's happening is this.
        I have SQL Server on a remote hosting companies box.
        Over the past two weeks when I try to connect to the database, I am
        denied based on username and password.
        I then remote into the box, set the password back to my "original"
        setting and then can connect as normal.

        The only thing that Ive noticed is that there had been a server reboot
        right aroudn the time of the second sql outage.

        MB

        Comment

        • Erland Sommarskog

          #5
          Re: Sql Server Password Expiration?

          mbailey (matt.bailey@gm ail.com) writes:[color=blue]
          > What's happening is this.
          > I have SQL Server on a remote hosting companies box.
          > Over the past two weeks when I try to connect to the database, I am
          > denied based on username and password.
          > I then remote into the box, set the password back to my "original"
          > setting and then can connect as normal.
          >
          > The only thing that Ive noticed is that there had been a server reboot
          > right aroudn the time of the second sql outage.[/color]

          Seems like you should have a discussion with the hosting company.
          --
          Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

          Books Online for SQL Server SP3 at
          SQL Server 2025 redefines what's possible for enterprise data. With developer-first features and integration with analytics and AI models, SQL Server 2025 accelerates AI innovation using the data you already have.

          Comment

          Working...