Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 window 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 stackoverflow.com Aug 16 '12 at 3:10

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

add comment

4 Answers 4

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
show 8 more comments
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 fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-snc6/s480x480/… –  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
show 8 more comments

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
add comment
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'YourNewPassword'
GO
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.