Enable Mixed Authentication Mode

For Integrated Security to work correctly, Microsoft SQL Server Management Studio must be configured to allow Mixed authentication.

1. Open Microsoft SQL Server Management Studio.
2. In the Object Explorer, right-click the server name, and then click Properties.
3. Select the Security page.
4. In the Server authentication section, select Mixed mode.