Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Server 2005 Developer Edition --  Named Instance

Posted on 2011-10-22
Medium Priority
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
  • 2
LVL 13

Accepted Solution

dwkor earned 1000 total points
ID: 37013929
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

ID: 37014063
LVL 37

Assisted Solution

ValentinoV earned 1000 total points
ID: 37014099
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: http://www.computeruser.com/articles/4-methods-to-change-ms-sql-server-password.html

Author Closing Comment

ID: 37122915

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Integration Management Part 2
Loops Section Overview

579 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