• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1068
  • Last Modified:

Add Northwind database to SQLExpress

Dear Dir,

When I downloaded SQLExpress, I could not find the Northwind database in it.
Where can I download this database and include in the SQLExpress?

Thanks,
JT
0
jtran007
Asked:
jtran007
  • 5
  • 4
2 Solutions
 
alainbrydenCommented:
You need to create these databases. You can download scripts to load this and other sample databases here:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en
0
 
Mohit VijayCommented:
try it...

1) Navigate to the following URL and lick the Download button - http://www.microsoft.com/downloads/details.aspx?familyid=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en

2) Complete the download and install process. This places the necessary files for Northwind (and Pubs) into the "c:\Sql Server 2000 Sample Databases" folder.

3) Open a command window. (Go to Start, Run, type Command and click OK)

4) Change the directory to the sample databases (type:  cd c:\SQL Server Sample Databases)

5) Type or paste the following into the command window replacing computerName with the actual name of your computer:

   osql -E -S computerName/SqlExpress -i instnwnd.sql

6) now go to VS and create a data connection using the computerName\sqlexpress as the Server name in the Add Connection dialog. The Northwind database should now be available.
0
 
jtran007Author Commented:
Hi VjSoft,

I downloaded the file from the website you indicated. It is *.msi file.
Do I have to run this program ? How can I get the file name instnwnd.sql file?

Thanks,
JT
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Mohit VijayCommented:
Yes please run it.
Have you downloaded it from Microsoft Site? If yes, ok run this, it will install your required database.
0
 
Mohit VijayCommented:
You have to follow above steps (http:#a33649767)
0
 
jtran007Author Commented:
Hi VjSoft,

I google this file (instnwnd.sql), and I run the command. But I got the error like:
[DBNETLIB]SQL Server does not exist or access denied

So the command  osql -E -S computerName/SqlExpress -i instnwnd.sql

in which  computerName is the servername ???

Thanks,
JT
0
 
Mohit VijayCommented:
yes computer name is server name.

Actually In default installation, your computer name will always be servername

What you provide when you login into sQL server using Manage consol? that server name will be in place of "computerName/SqlExpress"
0
 
jtran007Author Commented:
Hi VjSoft,

I enterd my correct computer name, but still not working.
Any ideas?

Thanks,
JT
0
 
jtran007Author Commented:
Thanks,
JT
0
 
jtran007Author Commented:
Hi,

 Why I can't split points here?

Thanks,
JT
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now