SQL Server 2005 Developer Edition -- Named Instance

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.???

Thanks
niceguy971Asked:
Who is Participating?
 
dwkorCommented:
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
0
 
dwkorCommented:
0
 
ValentinoVBI ConsultantCommented:
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
0
 
niceguy971Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.