SQL Server Connection Strings – dot(“.”) or “(local)” or “(localdb)”

by

. and (local) and YourMachineName are all equivalent, referring to your own machine.

(LocalDB)\instance is SQL Server 2012 Express only.

The other parts are depending on how you install – if you install with an instance name – then you need to spell that instance name out (SQL Server Express by default uses the SQLEXPRESS instance name, while other editions of SQL Server will try to use the default instance without any special name).

So for a “normal” SQL Server installed with all default options on your local machine, use

.    or   (local)     or          YourMachineName

For SQL Server Express installed with all the default settings, use

.\SQLEXPRESS    or   (local)\SQLEXPRESS     or          YourMachineName\SQLEXPRESS

If you look at the SQL Server Configuration Manager (launch it from the start menu), you’ll see:

enter image description here

If the SQL Server entry reads (MSSQLSERVER) then that’s that default instance (without any name) – otherwise you’d see the instance name in brackets

More Related Contents:

  1. SQL Server Configuration Manager cannot be found
  2. How to automatically generate unique id in SQL like UID12345678?
  3. How can I schedule a job to run a SQL query daily?
  4. Difference between partition key, composite key and clustering key in Cassandra?
  5. Reset identity seed after deleting records in SQL Server
  6. Android Pre-Populated Database [duplicate]
  7. How to handle authentication/authorization with users in a database?
  8. What’s the difference between a catalog and a schema in a relational database?
  9. How can I merge many SQLite databases?
  10. Difference between scaling horizontally and vertically for databases [closed]
  11. Create a view with ORDER BY clause
  12. Best practices for storing postal addresses in a database (RDBMS)?
  13. What are the advantages of using a single database for EACH client?
  14. Is it possible to generate django models from the database?
  15. Run a single Maven plugin execution?
  16. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’
  17. How to create an auto delete mechanism for firestore? (deleting data after time period) [closed]
  18. Do stored procedures run in database transaction in Postgres?
  19. What is a View in Oracle?
  20. Convert SQLITE SQL dump file to POSTGRESQL
  21. Spring Batch Framework – Auto create Batch Table
  22. What are the main differences between Redis Pub/Sub and Redis Stream?
  23. List of standard lengths for database fields
  24. How to get item count from DynamoDB?
  25. How do I change db schema to dbo
  26. How to find SQLITE database file version
  27. How to subtract 30 days from the current date using SQL Server
  28. Oracle: How do I convert hex to decimal in Oracle SQL?
  29. SQL Server: +(unary) operator on non-numeric Strings
  30. Pros/cons of document-based databases vs. relational databases

Leave a Comment