Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Problem With AdventureWorks Expand / Collapse
Author
Message
Posted Sunday, December 02, 2012 12:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, December 02, 2012 1:00 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:36 PM
Points: 571, Visits: 3,737
What did you try? Did you try to attach it, restore it?
Post #1391743
Posted Sunday, December 02, 2012 2:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, December 02, 2012 2:27 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:36 PM
Points: 571, Visits: 3,737
did you ever attach the database? does it show up under the Databases folder in SSMS?
Post #1391747
Posted Sunday, December 02, 2012 6:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, December 02, 2012 6:45 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:36 PM
Points: 571, Visits: 3,737
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
Posted Monday, December 03, 2012 12:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, December 03, 2012 12:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, December 03, 2012 12:36 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:36 PM
Points: 571, Visits: 3,737
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
Posted Monday, December 03, 2012 2:19 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 9:01 AM
Points: 684, Visits: 1,344
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 »

Add to briefcase 12»»

Permissions Expand / Collapse