--- title: Retrieving your SQL LocalDB Instance Name: A How-To Guide description: A quick tip for finding a SQL Server LocalDB instance name using the command line. Run SQLLocalDb.exe i to list configured databases, or SQLLocalDB.exe i... canonical: https://daily.dev/posts/retrieving-your-sql-localdb-instance-name-a-how-to-guide-co91uzc87 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Retrieving your SQL LocalDB Instance Name: A How-To Guide | daily.dev og:description: A quick tip for finding a SQL Server LocalDB instance name using the command line. Run SQLLocalDb.exe i to list configured databases, or SQLLocalDB.exe i... og:url: https://daily.dev/posts/retrieving-your-sql-localdb-instance-name-a-how-to-guide-co91uzc87 og:image: https://api.daily.dev/og/posts/cO91UZc87.png og:image:alt: Retrieving your SQL LocalDB Instance Name: A How-To Guide og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Retrieving your SQL LocalDB Instance Name: A How-To Guide **[Code4IT](https://daily.dev/sources/code4it)** · 2 min read · 0 upvotes · 0 comments ## Summary A quick tip for finding a SQL Server LocalDB instance name using the command line. Run SQLLocalDb.exe i to list configured databases, or SQLLocalDB.exe i "InstanceName" for details on a specific instance like version, owner, and state. Use Windows Authentication when connecting via SSMS, and wrap instance names containing spaces in quotes. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I find the name of my SQL Server LocalDB instance? Run SQLLocalDb.exe i in the terminal, where i stands for information, to list all configured LocalDB instances and their names. For details on a specific instance, including version, owner, and current state, run SQLLocalDB.exe i "InstanceName" with the real instance name. When connecting through SQL Server Management Studio, use Windows Authentication. _daily.dev surfaces practical database tips like this for developers debugging local SQL setups._ ### How do I create or delete a SQL LocalDB instance from the command line? Use SQLLocalDB.exe with its various commands to create, delete, start, and stop instances. Running SQLLocalDB.exe -? displays the full list of available commands. Note that spaces are treated as delimiters, so instance names containing spaces must be wrapped in quotes when passed as arguments. _Developers managing local SQL environments can find quick command-line references on daily.dev._ ## Similar posts on daily.dev - [SQL Server on Azure Local is now generally available](https://daily.dev/posts/sql-server-on-azure-local-is-now-generally-available-xrfa8g07s) · Microsoft Azure · 0 upvotes · 0 comments - [Set Your Application Names Before You Wish You Had.](https://daily.dev/posts/set-your-application-names-before-you-wish-you-had--bpdb7heiu) · Brent Ozar · 0 upvotes · 0 comments - [A better way to work with SQL Server](https://daily.dev/posts/a-better-way-to-work-with-sql-server-thprghiwd) · InfoWorld · 3 upvotes · 0 comments - [How to build an app on Azure SQL with an AI coding agent](https://daily.dev/posts/how-to-build-an-app-on-azure-sql-with-an-ai-coding-agent-hyseem3y2) · DevBlogs · 0 upvotes · 0 comments --- Tags: [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server) [View this post on daily.dev](https://daily.dev/posts/retrieving-your-sql-localdb-instance-name-a-how-to-guide-co91uzc87) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Retrieving your SQL LocalDB Instance Name: A How-To Guide","url":"https://daily.dev/posts/retrieving-your-sql-localdb-instance-name-a-how-to-guide-co91uzc87","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/retrieving-your-sql-localdb-instance-name-a-how-to-guide-co91uzc87"},"datePublished":"2026-10-04T13:07:39.763Z","dateModified":"2026-10-04T13:15:51.331Z","description":"A quick tip for finding a SQL Server LocalDB instance name using the command line. Run SQLLocalDb.exe i to list configured databases, or SQLLocalDB.exe i...","image":"https://media.daily.dev/image/upload/s--foaA6JGU--/f_auto/v1722860399/public/Placeholder%2004","thumbnailUrl":"https://media.daily.dev/image/upload/s--foaA6JGU--/f_auto/v1722860399/public/Placeholder%2004","isAccessibleForFree":true,"articleSection":"Code4IT","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Code4IT","logo":"https://media.daily.dev/image/upload/s--OaaG4G10--/f_auto,q_auto/v1791119049/logos/code4it?_a=BAMAMicg0","url":"https://daily.dev/sources/code4it"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/retrieving-your-sql-localdb-instance-name-a-how-to-guide-co91uzc87","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"microsoft-sql-server","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Code4IT","item":"https://daily.dev/sources/code4it"},{"@type":"ListItem","position":3,"name":"Retrieving your SQL LocalDB Instance Name: A How-To Guide"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/retrieving-your-sql-localdb-instance-name-a-how-to-guide-co91uzc87#faq","mainEntity":[{"@type":"Question","name":"How do I find the name of my SQL Server LocalDB instance?","acceptedAnswer":{"@type":"Answer","text":"Run SQLLocalDb.exe i in the terminal, where i stands for information, to list all configured LocalDB instances and their names. For details on a specific instance, including version, owner, and current state, run SQLLocalDB.exe i \"InstanceName\" with the real instance name. When connecting through SQL Server Management Studio, use Windows Authentication. daily.dev surfaces practical database tips like this for developers debugging local SQL setups."}},{"@type":"Question","name":"How do I create or delete a SQL LocalDB instance from the command line?","acceptedAnswer":{"@type":"Answer","text":"Use SQLLocalDB.exe with its various commands to create, delete, start, and stop instances. Running SQLLocalDB.exe -? displays the full list of available commands. Note that spaces are treated as delimiters, so instance names containing spaces must be wrapped in quotes when passed as arguments. Developers managing local SQL environments can find quick command-line references on daily.dev."}}]} ```