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.
Sql-server – SQl Server Password Change after installation
passwordsql serversql-server-2005ssms
Related Question
- DB2 to require password each time
- Sql-server – How to change default database to all logins
- Sql-server – SA user password for software which automatically installs SQL Server 2005
- Sql-server – ssms does not let me change to server authentication mode and I can not log in
- Sql-server – SQL Server mixed mode authentication not being set
Best Answer
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