unlock the sa account in SQL 2005

Posted on 2006-05-12
Last Modified: 2012-05-05
How do you unlock the sa account in SQL 2005.
Question by:pronetsol
    LVL 75

    Expert Comment

    by:Anthony Perkins
    You use a valid password ...
    LVL 11

    Accepted Solution

    you can login with windows Authentcation and then changes the password of sa account.

    for run below satement you should need to be a part of db owner.

    sp_password NULL,'new password','sa'
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Please skip me and award all points to ved17nov
    LVL 75

    Expert Comment

    by:Anthony Perkins

    I suspect you may have missed my comment.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now