January 8, 2013

SQL Server 2008 can't login with newly created user

SQL Server was not configured to allow mixed authentication.
Here are steps to fix:
  1. Right-click on SQL Server instance at root of Object Explorer, click on Properties
  2. Select Security from the left pane.
  3. 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).

    I wish Microsoft has better document.

    Source: http://stackoverflow.com/questions/1719399/sql-server-2008-cant-login-with-newly-created-user

1 comment:

  1. Excellent article! I am agree with the author's point of view.
    Computer data removal scenario is normally a problem for the person.
    However for the simplicity of end users, scientific study has proposed an alternative for data damage problems.
    Consumer need to be well aware of the available info recovery tools so that he is able to handle the info damage situation in just a best way.
    outlook mail file