Link to home
Start Free TrialLog in
Avatar of jtran007
jtran007

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of alainbryden
alainbryden
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jtran007
jtran007

ASKER

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
Yes please run it.
Have you downloaded it from Microsoft Site? If yes, ok run this, it will install your required database.
You have to follow above steps (http:#a33649767)
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
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"
Hi VjSoft,

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

Thanks,
JT
Thanks,
JT
Hi,

 Why I can't split points here?

Thanks,
JT