What is the sql connection string I need to use to access localhost\SQLEXPRESS with Windows Authentication or SQL Authentication?

by

Try using Windows authentication:

Data Source=localhost\SQLEXPRESS;Initial Catalog=test;Integrated Security=SSPI;

More Related Contents:

  1. If condition in SQL Server 2008
  2. Comma separated results in SQL
  3. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  4. Which are more performant, CTE or temporary tables?
  5. Search all tables, all columns for a specific value SQL Server [duplicate]
  6. Preferred Method of Storing Passwords In Database
  7. When/Why to use Cascading in SQL Server?
  8. SQL WHERE.. IN clause multiple columns
  9. SQL Server: combining multiple rows into one row
  10. Database scheme, autoincrement
  11. Query to list all stored procedures
  12. How do I search an SQL Server database for a string?
  13. SQL Server: Index columns used in like?
  14. SQL Server – parameter sniffing
  15. Does the order of columns in a WHERE clause matter?
  16. How can I select from list of values in SQL Server
  17. Configure Lucene.Net with SQL Server
  18. SQL Server tables: what is the difference between @, # and ##?
  19. Getting execute permission to xp_cmdshell
  20. Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility
  21. Import / Export database with SQL Server Server Management Studio
  22. Forcing a query timeout in SQL Server
  23. Sql Server – connect with windows authentication
  24. SSRS report definition is newer than Server
  25. Joining multiple tables returns NULL value
  26. Which join syntax is better?
  27. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  28. SQL SERVER PIVOT table with joins and dynamic columns
  29. How to maintain the order of insertion in SQL Server
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment