Install northwind to sqlserver failed

Dear EE members,

I am new to sqlserver and I have downloaded Visual Web Developer 2008 Express Edition.
Now, I want to add Northwind db to the sqlserver. But I failed with the following error:

 installation
Any idea to resolve this problem?

Rgds,

yjchong514
LVL 6
yjchong514Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Anthony PerkinsConnect With a Mentor Commented:
It sounds like you may have better luck installing SQL Server Management Studio Express, rather than trying to connect using the command line.  But then that is just me...
0
 
tigin44Commented:

do the windows account unser which you are running the install script have a login on the server? As I see NO. First you should get enough privilages to connect and run that script.
0
 
yjchong514Author Commented:
I am using XP Pro. How to add user to SQL Server Express and provide privilege to it?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
yjchong514Author Commented:
0
 
tigin44Commented:
usually the windows built in admin account have access to the sql server by default. Add your account to that windows group or change to one of that accounts and run the script...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
well, the Northwind db is not for sql 2008 ...
you want normally the AdventureWorks db.

see the download page:
http://msftdbprodsamples.codeplex.com/
0
 
Anthony PerkinsConnect With a Mentor Commented:
If you are trying to install Northwind here is the link (even though it states SQL Server 2000, you can use it with 2008):
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Microsoft® SQL Server® 2008 Management Studio Express
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b
0
 
yjchong514Author Commented:
any command line tutorial to view northwind instance and sql query?
0
 
Anthony PerkinsCommented:
>>any command line tutorial <<
What do you mean?  All you have to do is download and install.  It does not get simpler than that.
0
 
yjchong514Author Commented:
My PC not fulfill the requirement to install 2008 Management Studio Express. Hence, I would like to take
a look on command line.
0
 
yjchong514Author Commented:
Requirement problem solved.
0
All Courses

From novice to tech pro — start learning today.