App Muncher

Issues faced - solutions identified - shared with community.

Missed enabling mixed mode authentication while installing SQL server.


  1. To enable it open SQL Server Management Studio.
  2. Select your database server, right-click and select properties.
  3. In Properties, Select SECURITY and enable SQL Server and Windows Authentication mode
  4. Open database server instance and expand SECURITY.
  5. Expand LOGIN, select user SA
  6. In SA Properties, select STATUS, Grant Permission and Enable login
  7. Update SA password in General, restart SQL Server service.
  8. Now access Management Studio with sa.


No comments:

Post a Comment

| Designed by AppMuncher