SQL Server 2008 can’t login with newly created user

by

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.

    enter image description here

  4. Right-click on the SQL Server instance, select Restart (alternatively, open up Services and restart the SQL Server service).

This is also incredibly helpful for IBM Connections users, my wizards were not able to connect until I fxed this setting.

More Related Contents:

  1. Removing the remembered login and password list in SQL Server Management Studio
  2. What is the use of GO in SQL Server Management Studio & Transact SQL?
  3. What is the best way to auto-generate INSERT statements for a SQL Server table?
  4. How to see query history in SQL Server Management Studio
  5. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  6. sql server invalid object name – but tables are listed in SSMS tables list
  7. How to add Active Directory user group as login in SQL Server
  8. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  9. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  10. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  11. Query times out when executed from web, but super-fast when executed from SSMS
  12. How do you specify a different port number in SQL Management Studio?
  13. Unique constraint on multiple columns
  14. An attempt to login using SQL authentication failed
  15. Format SQL in SQL Server Management Studio
  16. Import / Export database with SQL Server Server Management Studio
  17. SQL Server Login error: Login failed for user ‘NT AUTHORITY\SYSTEM’
  18. SQL Server (localdb)\v11.0 explained
  19. The request failed or the service did not respond in a timely fashion?
  20. FOR JSON PATH results in SSMS truncated to 2033 characters
  21. Export from SQL Server to Excel
  22. hide/remove header and footer
  23. SQL Server: SELECT only the rows with MAX(DATE)
  24. LEN function not including trailing spaces in SQL Server
  25. Scheduled run of stored procedure on SQL server
  26. SQL Server ORDER BY date and nulls last
  27. Best way to implement an audit trail in SQL Server?
  28. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  29. What happens to the primary key Id when it goes over the limit?
  30. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰

Leave a Comment