如何为SQL Server LocalDB创建永久别名？

Great question—this is a super common pain point with LocalDB since its named pipes are dynamically generated on startup. Luckily, there are two solid approaches to get a "permanent alias" effect:

1. Share Your LocalDB Instance (Simplest Method) #

LocalDB lets you share an instance with a fixed, user-defined name that doesn’t change between restarts. This acts like a permanent alias you can use to connect anytime.

Here’s how to set it up:

• First, make sure your instance is running:

  sqllocaldb start MSSQLLocalDB
  

• Open an elevated command prompt (admin rights required) and run:

  sqllocaldb share MSSQLLocalDB MyPermanentAlias
  

  Replace MyPermanentAlias with the fixed name you want to use (e.g., DevDB).
• To connect to this shared instance, use the connection string (localdb)\.\MyPermanentAlias—this will work even after restarting the LocalDB instance or your machine.
• If you ever need to stop sharing the instance:

  sqllocaldb unshare MyPermanentAlias
  

2. Auto-Update SQL Server Client Alias (For Strict Alias Use Cases) #

If you specifically need a traditional SQL Server client alias (e.g., for apps that expect a standard alias name), you can automate updating the alias to point to the current dynamic named pipe each time the instance starts.

Step-by-Step Setup: #

1. Get the current named pipe: Run this to see your instance’s active pipe:

   sqllocaldb info MSSQLLocalDB
   

   Look for the line starting with Named pipe:—this value changes on each startup.

2. Create a script to update the alias:
   Use this PowerShell script (run as admin) to start the instance, fetch the pipe, and update the registry where SQL Server client aliases are stored:

   # Start the LocalDB instance
   sqllocaldb start MSSQLLocalDB
   
   # Extract the current named pipe
   $pipeDetails = sqllocaldb info MSSQLLocalDB | Select-String "Named pipe"
   $activePipe = $pipeDetails -replace "Named pipe: ", ""
   
   # Update the 64-bit client alias registry entry
   $regPath = "HKLM:\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo"
   if (-not (Test-Path $regPath)) {
       New-Item -Path $regPath -Force | Out-Null
   }
   # Replace 'MyPermanentAlias' with your desired alias name
   Set-ItemProperty -Path $regPath -Name "MyPermanentAlias" -Value "DBNETLIB,$activePipe"
   
   # For 32-bit applications, uncomment and run this instead:
   # $regPath32 = "HKLM:\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo"
   # if (-not (Test-Path $regPath32)) {
   #     New-Item -Path $regPath32 -Force | Out-Null
   # }
   # Set-ItemProperty -Path $regPath32 -Name "MyPermanentAlias" -Value "DBNETLIB,$activePipe"
   

3. Automate the script:
   You can set this script to run on startup (via Task Scheduler) or create a shortcut to it so you run it manually before connecting to your database.

Notes: #

• Admin rights are required to modify the registry and share instances.
• Shared instances are visible to other users on your machine—if you don’t want that, stick with the alias update script.

内容的提问来源于stack exchange，提问作者Ryan Richardson