sample database in sql server 2005 Developer
-
hi everyone,
i'm trying to install the sample database AdventureWorks I followed the step-by-step in the tutorial book (installing after the setup). but i don't know why i cannot make a connection on it.
Anyone here knows how to workaround this problem.
I will appreciate any help!
-
We can't possibly give any good answer with this information. Which version of SQL Server 2005 have you installed? What tutorial book are you referring to? Where did you install AdventureWorks from?
-
I installed the Sql server 2005 Developer Edition. I'm referring to the Sql Server Tutorial of Microsoft Sql Server 2005. And I installed AdventureWorks going to the control panel and i clicked change button then i just followed the set up wizard and the AdventureWorks database came from the CD of MSSQL 2005 Developer Edition.
I did the steps in: To install the sample databases and samples after Setup. But then when I tried to register the AdventureWorks Database, in the New Server Registration Dialog Box, I clicked on the AdventureWorks (in the Connect to Database listbox), then I clicked TEST button, I'm getting an error says: "Cannot open database requested in login...."
So I thought it was installed but not attached, so what I did I used the ATTACH context menu in the Database, i looked for the .mdf file, but I'm still getting an error.
But I was wondering why when I installed AdventureWorks it didn't go to this path: n:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. It went here: n:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP. And I'm getting an error when i'm trying to attach it.
ope this makes my problem clear and hope you can help me.
Thanks you!
-
That location should not contain the data files, it contains only a script to create the database (and places the files in the same location as master) and csv files with data to import.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply