Skip to main content
Install and Attach Northwind Database in SQL Management Studio final

Install and Attach Northwind Database in SQL Management Studio

In this post I will show How we can download, install NorthWind Database in our SQL Management Studio.

Install and Attach Northwind Database in SQL Management Studio steps :

Step 1 :

Download the NorthWind Database required ZIP msi file from Microsoft website.

Link.

Step 2 :

Install the msi file from the download location. Double click on the msi file and follow the install instructions.Install and Attach Northwind Database in SQL Management Studio install 1

After successfully installing the NorthWind database msi file, your files will be located in folder :

“C:\SQL Server 2000 Sample Databases”

Please check it.

Step 3 : 

Open your SQL Management Studio and select Attach Database option from the menu of the connected server.

Install and Attach Northwind Database in SQL Management Studio sql attach

Attach Option will Pop-Up. In the Window select the .mdf file of your NorthWind databases files from the folders :

C:\SQL Server 2000 Sample Databases

Install and Attach Northwind Database in SQL Management Studio sql select

And Click Ok.

Install and Attach Northwind Database in SQL Management Studio sql selected

NorthWind Database will be attached and restored on your SQL Server. Expand the Databases node on your SQL Management Studio Server node :

Install and Attach Northwind Database in SQL Management Studio final



One thought to “Install and Attach Northwind Database in SQL Management Studio”

Comments are closed.