Unable to login to SQL Server + SQL Server Authentication + Error: 18456

by

You need to enable SQL Server Authentication:

  1. In the Object Explorer, right click on the server and click on “Properties”

DBMS Properties dialog

  1. In the “Server Properties” window click on “Security” in the list of pages on the left. Under “Server Authentication” choose the “SQL Server and Windows Authentication mode” radio option.

SQL Server Authentication dialog

  1. Restart the SQLEXPRESS service.

More Related Contents:

  1. Export from SQL Server to Excel
  2. How to get cumulative sum
  3. How to check if a column exists in a SQL Server table
  4. Get first day of week in SQL Server
  5. SQL Server query to find all permissions/access for all users in a database
  6. Infinite loop CTE with OPTION (maxrecursion 0)
  7. How Can I Log and Find the Most Expensive Queries?
  8. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  9. SQL Server add auto increment primary key to existing table
  10. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  11. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  12. INSERT INTO vs SELECT INTO
  13. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  14. Do while loop in SQL Server 2008
  15. How to: Create trigger for auto update modified date with SQL Server 2008
  16. How to update primary key
  17. error when inserting into table having instead of trigger from entity data framework
  18. Case sensitive variables in SQL Server
  19. Transpose rows and columns with no aggregate
  20. What happens to the primary key Id when it goes over the limit?
  21. SQL Recursive CTE: Finding objects linked by property
  22. Convert decimal time to hours and minutes
  23. nvarchar(max) vs NText
  24. How to find the boundaries of groups of contiguous sequential numbers?
  25. What are row, page and table locks? And when they are acquired?
  26. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  27. Error converting data types when importing from Excel to SQL Server 2008
  28. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  29. SQL Server 2008 Spatial: find a point in polygon
  30. Implementing one-to-zero-or-one relation in SQL Server

Leave a Comment