Enable Mixed Authentication Mode
For Integrated Security to work correctly, Microsoft SQL Server Management Studio must be configured to allow Mixed authentication.
- Open Microsoft SQL Server Management Studio.
- In the Object Explorer, right-click the server name, and then click Properties.
- Select the Security page.
- In the Server authentication section, select Mixed mode.