- To enable it open SQL Server Management Studio.
- Select your database server, right-click and select properties.
- In Properties, Select SECURITY and enable SQL Server and Windows Authentication mode
- Open database server instance and expand SECURITY.
- Expand LOGIN, select user SA
- In SA Properties, select STATUS, Grant Permission and Enable login
- Update SA password in General, restart SQL Server service.
- Now access Management Studio with sa.
Enable Mixed Mode authentication in SQL Server
Missed enabling mixed mode authentication while installing SQL server.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment