Adventureworks 2008 OLTP

Question

HI,

I am completly new to Report Builder 2.0 and Im tryuing to follow the tutorials. I have downloaded AdventureWorks 2008 OLTP but I was unable to understand the direction about changing the DDL and saving it as " C:\{AdventureWorks 2008 OLTP Script Path}\instawdb.sql in SQL Server Management Studio "

Can someone help me install Adventureworks on my Microsoft SQL Server?

Answer 1

Hi Santiago,

You can download AdventureWorks from here. To install it, just execute downloaded file.

Cheers,

Soheil

---

MCP, MCTS, MCITP

Answer 2

Hello,

Did you try the steps at http://social.technet.microsoft.com/wiki/contents/articles/3735.sql-server-samples-readme-en-us.aspx#Readme_TOC_worknow? After attaching the database in SQL Management Studio, you will need to remove the log file from the list of files to attach. Select the database details ListView item with Message of Not Found and click the Remove button. I’ll check back in a couple of days to see if this helps.

Answer 3

please read the last posting here http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/9dd84ee1-8a97-49a1-8f4b-ab0fad4e0d9d

and follow the instruction to create Adventureworks DB for SQL Server 2008.

If you're using a different version of SQL Server - eg. 2008 R2 - you need to download a different version of AdventureWorks DB and the installation process is different.

If you start with Report Builder from scratch than I would recommand that you start directly with Report Builder 3.0 and not with 2.0.

Tutorial website for Report Builder 3.0: http://technet.microsoft.com/en-us/library/dd239338%28v=sql.105%29.aspx

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 4

Hello,

Thanks for your help it was very useful, now I have encountered another problem.

Ultimatly I am going to use Deltek Vision 6.1 as my database for reporting. The manual says that Report Builder 1.0 is the only compatible Report Builder. Where can I get this tool?

Santi

Answer 5

hi Santi

see the answer from Thierry: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3ad940c7-311a-4407-b341-07f5cc238014/

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.