SQL password help

Discussion in 'Windows Small Business Server' started by Brian, May 10, 2007.

  1. Brian

    Brian Guest

    Hello,

    We are running into a problem where the sqlsrvr.exe process is using over
    1GB of memory. This is causing performance issues on the server. I've come
    across a site that suggests adjusting the max/min memory usage settings on
    SQL. My problem seems to be that we do not know what the SA password is to
    do these adjustments. Does anyone know a way to reset the SA password on SQL
    server for Small Business Server 2003?

    Side note: anyone else experiencing the high memory usage of sqlsrvr.exe
    process? If so, what have you done about it? Rebooting the server seems to
    help, but the high usage creeps up after a few days.

    Thanks in advance ...Brian
     
    Brian, May 10, 2007
    #1
    1. Advertisements

  2. Brian

    Brian Guest

    Sorry, I meant sqlservr.exe.
     
    Brian, May 10, 2007
    #2
    1. Advertisements

  3. You can change the SA password in SQL Management Studio, but you shouldn't
    have to, and you shouldn't need the SA password to throttle the RAM usage.
    Your SQL instances are probably using Windows auth anyway. To throttle the
    memory usage of the SQL instances, see
    http://msmvps.com:80/blogs/bradley/archive/2005/02/04/34984.aspx.

    SQL normally grabs up all the memory it can get its hands on, similar to
    Exchange. That's why it's temporarily remedied by a reboot - it takes a
    while for it to get back up to speed.
     
    Dave Nickason [SBS MVP], May 10, 2007
    #3
  4. Brian

    bass_player Guest

    You need sysadmin privileges to do this. This is a default privilege for the
    Builtin\Administrators which includes your domain and admins and the sa
    account. You can use a domain admin account to reset your sa password as well
     
    bass_player, May 11, 2007
    #4
  5. Brian

    yee lau Guest

    Try using command prompt to <a href="http://www.passwordunlocker.com/knowledge/change-sql-server-password.html">change sql sa password</a>.
    <i>Osql ?S yourservername ?E
    1> EXEC sp_password NULL, 'yourpassword', 'sa'
     
    yee lau, Sep 3, 2010
    #5
  6. Do not handle SQL Server Admin and User password recovery through any manual method. So i recommend you to use MS SQL Password recovery software whichan entrusted solution to recover the lost SQL password. visit here to findout how to perform sql password recovery http://www.sqlrepairtool.org/extract-sql-server-user-password.html
     
    enriquemallon, Feb 1, 2014
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.