Solved

Install northwind to sqlserver failed

Posted on 2011-02-20
11
1,013 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:yjchong514
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 26

Expert Comment

by:tigin44
ID: 34936189

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
 
LVL 6

Author Comment

by:yjchong514
ID: 34936220
I am using XP Pro. How to add user to SQL Server Express and provide privilege to it?
0
 
LVL 6

Author Comment

by:yjchong514
ID: 34936226
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 26

Expert Comment

by:tigin44
ID: 34936235
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34937128
well, the Northwind db is not for sql 2008 ...
you want normally the AdventureWorks db.

see the download page:
http://msftdbprodsamples.codeplex.com/
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 34940070
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
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 500 total points
ID: 34940085
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
 
LVL 6

Author Comment

by:yjchong514
ID: 34976940
any command line tutorial to view northwind instance and sql query?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34985608
>>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
 
LVL 6

Author Comment

by:yjchong514
ID: 34986282
My PC not fulfill the requirement to install 2008 Management Studio Express. Hence, I would like to take
a look on command line.
0
 
LVL 6

Author Comment

by:yjchong514
ID: 35024125
Requirement problem solved.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question