How can I login to my MS SQL Server 2005 if I forgot my login password

Question

 

Hi,

 

I am using SQL Server 2005 at home.

My problem is I forgot my password to log in to my server.

I only remember user name is 'sa'.

I haven't used it for two to three months. So I forgot password.

Previously, When I used sql server 2000, my login is as windows login. so no problem.

But this time, I set seperate log in and I got this problem.

Any help will be appreciated.

Thanks

George

 

Answer 1

You can log onto the box with the Local Administrator Account. From there load up the management tools and login with a windows trusted connection. From there you can reset the sa password.

 

Answer 2

Thanks for your reply.

 

Local Administrator Account means my windows log in account or ????

Can you tell me clearer?

Sorry I am not too much IT-geek

Thanks

 

Answer 3

yes Local Administrator is the user who is a member of Local windows Admin Group ... So ideally the user which you are using to login to the system (since its your home pc) should be a local admin user. In Sql server management studio select Windows Authentication and the login.. change the SA password..

 

Madhu

 

 

Answer 4

Madhu K Nair wrote:

yes Local Administrator is the user who is a member of Local windows Admin Group ... So ideally the user which you are using to login to the system (since its your home pc) should be a local admin user. In Sql server management studio select Windows Authentication and the login.. change the SA password..   Madhu

 

Thanks Madhu. I will try when I got home as I am still at work now.

George

Answer 5

 I hope the following article will help: http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

 

  Please let us know if you have any further problems or questions.

 

  Thanks,

  -Raul Garcia

  SDE/T

  SQL Server Engine

 

Answer 6

Thanks Raul.

I will try it.

 

Answer 7

Tried on Vista Business and SQL 2005 Express.
All I'm getting - no permission to perform this action.

Answer 8

login in as  Windows Authentication，then you can change the sa's password! Good luck!

---

Thx