<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server Newbies
»
Problem With AdventureWorks
12 posts, Page 1 of 2
1
2
»»
Problem With AdventureWorks
Rate Topic
Display Mode
Topic Options
Author
Message
pirrot
pirrot
Posted Sunday, December 02, 2012 12:22 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:46 AM
Points: 9,
Visits: 16
Hello:
I am new to this forum and would like some help with SQL Server 2008 R2 Express. I downloaded SQL with no problems, but I'm having problems loading the sample databases so SQL Server can recognize it.
Thank you for your help!
Post #1391742
pietlinden
pietlinden
Posted Sunday, December 02, 2012 1:00 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 4:13 PM
Points: 186,
Visits: 1,583
What did you try? Did you try to attach it, restore it?
Post #1391743
pirrot
pirrot
Posted Sunday, December 02, 2012 2:14 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:46 AM
Points: 9,
Visits: 16
I downloaded the AdventureWorksR2 data file on my C-Drive Folder. Then I opened my SQL Server Express and opened a new query. From there I could not navigate to the database on my C-Drive.
Post #1391746
pietlinden
pietlinden
Posted Sunday, December 02, 2012 2:27 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 4:13 PM
Points: 186,
Visits: 1,583
did you ever attach the database? does it show up under the Databases folder in SSMS?
Post #1391747
pirrot
pirrot
Posted Sunday, December 02, 2012 6:17 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:46 AM
Points: 9,
Visits: 16
I don't know how to attach the database.
Post #1391755
pietlinden
pietlinden
Posted Sunday, December 02, 2012 6:45 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 4:13 PM
Points: 186,
Visits: 1,583
Did you unzip the database file(s)? There should be two - one is an MDF file (database file) and the other is the LDF.
Open SSMS.
Right-click on Databases
choose Attach Database...
You should be prompted for the location of the MDF and LDF files. If they're in the same directory, it's super easy.
Post #1391757
pirrot
pirrot
Posted Monday, December 03, 2012 12:30 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:46 AM
Points: 9,
Visits: 16
I think I'm almost there. One problem though. When I right click to attach the database and select the files I get this error message. "An error occurred when attaching the database(s). Click the hyperlink in the Message column for details". I'm not sure where the message column is. I only see the hyperlink to the view connection properties.
Post #1392110
pirrot
pirrot
Posted Monday, December 03, 2012 12:35 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:46 AM
Points: 9,
Visits: 16
I found the error msg. It says "Unable to open the physical file "C:\SSQL\AdventureWorksR2_Data.mdf". Operating System error 5: "5(Access is denied.)" (Microsoft SQL Server, Error: 5120).
Post #1392111
pietlinden
pietlinden
Posted Monday, December 03, 2012 12:36 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 4:13 PM
Points: 186,
Visits: 1,583
Without an error message, I'm afraid I can't help you.
Can't diagnose what I can't see! Do it again and see if you can get an error message. Are you trying to use the 2012 version of AdventureWorks by accident? That would make 2008 throw a fit, I'm sure. If necessary, go to CodePlex and make sure you have downloaded the correct version.
Post #1392112
Joie Andrew
Joie Andrew
Posted Monday, December 03, 2012 2:19 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, May 06, 2013 5:58 AM
Points: 535,
Visits: 1,010
Does the account that SQL was setup as have permissions to the location where you put the MDF file?
Joie Andrew
"Since 1982"
Post #1392142
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
