Message
  • You must log in first
  • Please Login

Database Setup Information

Description:This tutorial demonstrates how to connect to the tutorial sample database provided by BusinessObjectsUsers.com. The setup is the sames as the Introduction lessons except for the login and database name.
Initial Instructions:

Step 1: Test database connectivity to our sample database

We use a SQL Server 2008 sample database based on Microsoft's Northwind database. Download the report listed below and run it in preview mode. The video tutorial will guide you through all of the test and configuration proceduress.

DataConnectTest.rpt

To connect to our database you will need the following information:

  • Server: 72.3.165.51,4120
  • User ID: 400248_advanced
  • Password:123Password (case sensitive)
  • Database: 400248_AdventureWorks
  • Review the video for complete instructions

Step 2. Install the SQL Server 2008 Native Client (do only if the DataConnect report fails)

The files below can be used to update your computer's ability to connect to a SQL Server 2008 database using the connection method of SQL OLE DB. These files should only be downloaded and installed if you discover your computer's drivers are out of date (Step 1). The installation files were developed by Microsoft and are simply being re-distributed here. Detailed instruction are available on Microsoft's website. Click here to visit.

X86 Package (sqlncli.msi) - 4549 KB : Used for most 32bit Windows operating systems
X64 Package (sqlncli.msi) - 7963 KB : Used for most 64bit Windows operating systems
IA64 Package (sqlncli.msi) - 11112 KB : Used for Itanium Intel 64bit processors

  • Only one file needs to be downloaded to perform the installation
  • The most common package will be the X86 Package
  • Review the video for complete instructions
Expert Option
Another option is to install any version of SQL Server 2008 and load the sample database. The video does not show the steps required to do this, but we have provided the database in a ZIP file in the event you have to use this option or just simply want to.

AdventureWorks.zip

VideoTutorial

 

Business Objects Disclaimer

BUSINESSOBJECTSUSERS.COM, A TRADE NAME OF VISION HARVEST, INC., NOR ITS RESPECTIVE PRODUCTS OR SERVICES ARE AFFILIATED WITH, OR ENDORSED, LICENSED, OR SPONSORED BY BUSINESS OBJECTS, THE OWNER OF CRYSTAL REPORTS.

ALL OTHER NAMES MENTIONED HEREIN MAY BE TRADEMARKS OF THEIR RESPECTIVE OWNERS.