Visual Studio无法找到数据库作为数据连接，编程新手求助

数据老陈

2026-5-22

Hey there! Let's break down these two issues you're facing step by step—since you're just starting out, these are super common hurdles, so don't stress!

Issue 1: Missing content in the sample database installation link

Since the official link isn't working for you, let's manually grab and attach a sample database instead. Here's how:

First, download a widely-used sample database like AdventureWorks or Northwind (these are free, official resources from Microsoft).
Once downloaded, open SQL Server Management Studio (SSMS), connect to your local SQL Server instance (usually (local) or .\SQLEXPRESS).
Right-click on the Databases folder in the Object Explorer, select Attach....
In the Attach Databases window, click Add..., navigate to the downloaded .mdf file of the sample database, and follow the prompts to complete the attachment.

This usually boils down to missing components or incorrect setup. Try these fixes:

Check if the SQL Server service is running: Open the Windows Services app (press Win + R, type services.msc), find the service named SQL Server (SQLEXPRESS) (or your specific instance name), and make sure it's set to "Running". If not, right-click and start it.
Install required Visual Studio components: Open Visual Studio Installer, go to your installed workloads, and ensure you have the Data storage and processing workload checked. This installs the necessary drivers and tools for database connections.
Select the correct data source type: When adding a connection in Visual Studio, click the Change... button next to the data source field, and select Microsoft SQL Server from the list. If this option isn't present, the missing workload mentioned above is likely the issue.
Verify your server instance name: When setting up the connection, use the correct instance name—for a default local installation, this is usually .\SQLEXPRESS or (localdb)\MSSQLLocalDB (for the lightweight LocalDB instance).