使用Microsoft SQL v17.9.1连接本地实例遇阻，求解决方法

Hey there! Let's walk through figuring out how to find your local SQL Server instance name and fix that connection error.

First, let's clarify why using your IPv4/IPv6 addresses might not be working right away: even if the SQL Server service is running, you might not have the TCP/IP protocol enabled for the instance, or you're missing the required port number for IP-based connections. But let's start with the easiest approach—locating your actual instance name first.

How to Find Your Local SQL Server Instance Name #

Here are three reliable methods to get the instance name:

• Via SQL Server Configuration Manager:
  Open the tool, expand the SQL Server Services node. Look for the service named SQL Server (XXX)—the text inside the parentheses is your instance name. If it just shows SQL Server (MSSQLSERVER), that's the default instance (no extra name required).
• Using Command Prompt:
  Launch a command prompt and run this command:

  sqlcmd -L
  

  This will list all SQL Server instances available on your network, including your local one. Look for entries starting with your computer name, followed by a backslash and the instance name (or just the computer name for the default instance).
• Through SSMS Browse Feature:
  Open SQL Server Management Studio, click the dropdown next to Server name, and select Browse for more.... Expand the Database Engine node under Local Servers—your local instance will be listed here.

How to Connect Using the Instance Name #

Once you have the instance name, connecting is straightforward:

• For the default instance (MSSQLSERVER): Use any of these as the server name:
  • . (a single dot)
  • localhost
  • (local)
  • Your computer's name
• For a named instance: Append the instance name with a backslash, like:
  • .\YourInstanceName
  • localhost\YourInstanceName
  • YourComputerName\YourInstanceName

Why Your IP Address Attempt Failed (And How to Fix It) #

If you still want to use an IP address to connect, follow these steps:

1. Go back to SQL Server Configuration Manager, expand SQL Server Network Configuration > Protocols for [YourInstanceName].
2. Ensure TCP/IP is set to Enabled.
3. Double-click TCP/IP, navigate to the IP Addresses tab. Scroll down to IPAll and note the TCP Port (default is 1433 for default instances; named instances might use a dynamic port).
4. In SSMS, enter your IP address followed by a comma and the port number, like 192.168.1.100,1433.

Give these steps a try—you should be able to connect to your local instance in no time!

内容的提问来源于stack exchange，提问作者Christopher Ell