Many times we installed sql server on window
authentication mode and after that we need to use It with Id and Password(Server
Authentication Mode)
Int hat case you can follow these steps to activate password mode.
Step 1: Login with Window Authentication mode
Step 2: Go to Security Folder
Step 3: Go to Logins
Step 4: Go to Sa and Right Click and Choose Properties
Step 5: General-- Enter Your passwords
Step 6:Server Role--Check Server Roles
Step 7: Status--Choose Grant and Enabled
Step 8: Click on OK
Step 9: Login with sa and your given Password