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
AI Thread Summary
The discussion focuses on configuring a database connection string for a local MS SQL Server 2012 Express instance. The user seeks to replace the string "(localdb)" with their computer name, aiming for a format like "Computer\MyInstance." It is clarified that using "localhost" in connection strings is a viable alternative to using the full computer or domain name when connecting to a local database server. This provides a simplified method for establishing connections without needing to reference the specific computer name.
Medicol
Messages
223
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
 
In my discussions elsewhere, I've noticed a lot of disagreement regarding AI. A question that comes up is, "Is AI hype?" Unfortunately, when this question is asked, the one asking, as far as I can tell, may mean one of three things which can lead to lots of confusion. I'll list them out now for clarity. 1. Can AI do everything a human can do and how close are we to that? 2. Are corporations and governments using the promise of AI to gain more power for themselves? 3. Are AI and transhumans...
Sorry if 'Profile Badge' is not the correct term. I have an MS 365 subscription and I've noticed on my Word documents the small circle with my initials in it is sometimes different in colour document to document (it's the circle at the top right of the doc, that, when you hover over it it tells you you're signed in; if you click on it you get a bit more info). Last night I had four docs with a red circle, one with blue. When I closed the blue and opened it again it was red. Today I have 3...
Back
Top