Can I Use My Computer Name Instead of (localdb) in My Database Server?

  • Thread starter Thread starter Medicol
  • Start date Start date
  • Tags Tags
    Computer
Click For Summary

Discussion Overview

The discussion revolves around whether a user can replace the string "(localdb)" with their computer name in the context of connecting to a local database server, specifically using MS SQL Server 2012 Express. The focus is on connection string formatting and local database access.

Discussion Character

  • Technical explanation, Conceptual clarification

Main Points Raised

  • One participant inquires if they can use their computer name "Computer" instead of "(localdb)" in their database server connection string.
  • Another participant asks for clarification on the operating system and database server being used.
  • A third participant confirms the use of Windows and MS SQL Server 2012 Express version.
  • It is suggested that "localhost" could be used in connection strings as an alternative to the full computer or domain name for connecting to a local database server.

Areas of Agreement / Disagreement

Participants have not reached a consensus on whether using the computer name instead of "(localdb)" is feasible, and the discussion remains unresolved regarding this specific substitution.

Contextual Notes

There may be limitations regarding the specific configurations of the database server and the implications of using different naming conventions in connection strings, which have not been fully explored.

Medicol
Messages
226
Reaction score
54
My computer name is "Computer" and my domain is MyDomain.com
My account to sign in is MyDomain\MyAccount.
My database instance is "(localdb)\MyInstance" - this is also my database server.
I don't want to use string "(localdb)", can I use my computer name for it such that my database server becomes
"Computer\MyInstance", for example ?
 
Computer science news on Phys.org
Windows and MS SQL Server 2012 Express version
 
If you are referring to the hostname in connection strings, then you can use "localhost" [1] there instead of your full computer or domain name if you want to connect to a local database server.

[1] http://en.wikipedia.org/wiki/Localhost
 

Similar threads

Replies
7
Views
3K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 16 ·
Replies
16
Views
3K
  • · Replies 21 ·
Replies
21
Views
4K
Replies
17
Views
7K
  • · Replies 9 ·
Replies
9
Views
5K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 1 ·
Replies
1
Views
1K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 7 ·
Replies
7
Views
2K