SQL Server 2005 Developer Edition --  Named Instance

Posted on 2011-10-22
Last Modified: 2012-05-12
I installed SQL Server 2005 Developer Edition on Windows XP (standalone computer) long time ago. I use SQL Server Management studio to connect to my instance..but I forgot the password.

Is it possibe to execute  SQL Server 2005 installation process again to re-install only Database

engine for my SQl Server instance (it's Named Instance)..and change .the password ..the same

instance that was installed long time ago.???

Question by:niceguy971
    LVL 13

    Accepted Solution

    You can reset password by starting sql serverwith -m switch (you can specify it in the configuration manager). In this mode the member of windows admin group would become sysadmins - so connect there under your windows account/ authentication and reset passwords
    LVL 13

    Expert Comment

    LVL 37

    Assisted Solution

    Assuming you're referring to the password of the 'sa' user, it's possible to change that password without knowing it.

    Logon to your named instance using a local administrator.  Easiest way to do this is to log on to your Windows using that local admin.  Then use the sp_password procedure to set the new password for sa.

    More info:

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    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

    8 Experts available now in Live!

    Get 1:1 Help Now