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.
I'll clarify demas's answer:
- Open SQL Server Management Studio
- Connect to the SQL Server instance using windows authentication
- In Object Explorer select the SQL Server and right click it
- Open Properties
- Open the Security tab
- In Server Authentication select Sql Server and Windows Authentification mode