Sql server cannot login after create user
December 15, 2013 Leave a comment
- RUN AS ADMINISTRATOR
- Right-click on SQL Server instance at root of Object Explorer, click on Properties
- Select Security from the left pane.
- Select the SQL Server and Windows Authentication mode radio button, and click OK.
- Right-click on the SQL Server instance, select Restart (alternatively, open up Services and restart the SQL Server service).