A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)

by

For SQL2008,

  • open Management Studio
  • Rt click on instance
  • go to properties
  • select Security
  • Under Server Authentication, check SQL Server and Windows Authentication Mode
  • hit OK

Restart the server using configuration manager.

More Related Contents:

  1. Create a view with ORDER BY clause
  2. How to run the same query on all the databases on an instance?
  3. SQL Update with row_number()
  4. How to write UTF-8 characters using bulk insert in SQL Server?
  5. Is a single SQL Server statement atomic and consistent?
  6. Connecting to MS SQL Server with Windows Authentication using Python?
  7. determining the character set of a table / database?
  8. How to query for Xml values and attributes from table in SQL Server?
  9. Should every User Table have a Clustered Index?
  10. cross apply xml query performs exponentially worse as xml document grows
  11. SQL Server Configuration Manager cannot be found
  12. Compute MD5 hash of a UTF8 string
  13. Sql Server replication requires the actual server name to make a connection to the server
  14. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  15. Convert from DateTime to INT
  16. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  17. SQL Server 2008 Spatial: find a point in polygon
  18. SQL server query to output the data shown below
  19. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  20. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  21. How to use a variable for the database name in T-SQL?
  22. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  23. Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
  24. INSERT INTO vs SELECT INTO
  25. How can I Insert data into SQL Server using VBNet
  26. How do you set autocommit in an SQL Server session?
  27. Milliseconds wrong when converting from XML to SQL Server datetime
  28. What are row, page and table locks? And when they are acquired?
  29. Bootstrapping SQL Express from WiX?
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment