Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have installed SQL Server 2005, but at the time of installation I forgot to change my password. Now I can access my database only in Windows authentication mode, and I want to access the database in mix mode. For that I need to know the username and password. Please tell me how I can change the password after installing SQL Server 2005.

share|improve this question

migrated from Aug 16 '12 at 3:10

This question came from our site for professional and enthusiast programmers.

up vote 2 down vote accepted

Enterprise Manager - Object Explorer - Server - Properties - Security - Server Authentification - Sql Server and Windows Authentification mode.

To change password: Security - Logins - sa - Password

Don't forget to restart te service

share|improve this answer
but i am not able to find the enterprise manager – Ankur Aug 6 '12 at 7:12
It will be helpfull if you attach the screnshot of you problem. – demas Aug 6 '12 at 7:13
I cannot read anything on this little image :) – demas Aug 6 '12 at 7:17
this is the screenshot of my problem. and now i m not able to log in with the window authentication. – Ankur Aug 6 '12 at 7:17

I'll clarify demas's answer:

  1. Open SQL Server Management Studio
  2. Connect to the SQL Server instance using windows authentication
  3. In Object Explorer select the SQL Server and right click it
  4. Open Properties
  5. Open the Security tab
  6. In Server Authentication select Sql Server and Windows Authentification mode
share|improve this answer
1.Login to sql server with windows authentication
2.Right click on server name
3.Click on properties
4.then click on securities
5.Then in Server authentication select mixed mode(windows+sql server authentication)
share|improve this answer
i am not able to log in into window authentication mode. it is giving me error. – Ankur Aug 6 '12 at 7:11
In your question you said you are able to access through windows authentication? – AnandPhadke Aug 6 '12 at 7:15
but now i am not able to login it is giving error... the screen shot of the errot is… – Ankur Aug 6 '12 at 7:20
Are you giving correct server name? – AnandPhadke Aug 6 '12 at 7:21
yes i am giving correct server name. – Ankur Aug 6 '12 at 7:23
USE [master]
share|improve this answer

protected by Paul White Apr 30 '15 at 15:00

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?