How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?

by

You can do it with SQL Management Studio –

Server Properties – Security – [Server Authentication section] you check Sql
Server and Windows authentication mode

Here is the msdn source – http://msdn.microsoft.com/en-us/library/ms188670.aspx

More Related Contents:

  1. incorrect syntax near keyword where [closed]
  2. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  3. How do I create a unique constraint that also allows nulls?
  4. How to convert SQL Server’s timestamp column to datetime format
  5. Multiple rows to one comma-separated value in Sql Server [duplicate]
  6. SQL Server: Difference between PARTITION BY and GROUP BY
  7. How do you truncate all tables in a database using TSQL?
  8. Import ‘xml’ into Sql Server
  9. Query times out when executed from web, but super-fast when executed from SSMS
  10. TSQL: How to convert local time to UTC? (SQL Server 2008)
  11. Efficient ISNUMERIC() replacements on SQL Server?
  12. Login to Microsoft SQL Server Error: 18456
  13. SQL Server datetime LIKE select?
  14. Is it possible to set a timeout for a SQL query on Microsoft SQL Server?
  15. What is a simple command line program or script to backup SQL server databases?
  16. SQL Server Output Clause into a scalar variable
  17. How to create a yes/no boolean field in SQL server?
  18. Best way to store time (hh:mm) in a database
  19. Using variable in SQL LIKE statement
  20. How do I select last 5 rows in a table without sorting?
  21. Why does a parameterized query produces vastly slower query plan vs non-parameterized query
  22. displaying multiple records by using resultset
  23. SELECT INTO a table variable in T-SQL
  24. How to display two digits after decimal point in SQL Server
  25. Include missing months in Group By query
  26. SQL Server equivalent to Oracle’s CREATE OR REPLACE VIEW
  27. In SQL Server, how can I find everywhere a column is referenced?
  28. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  29. Oracle sequence but then in MS SQL Server
  30. Convert float into varchar in SQL Server without scientific notation

Leave a Comment