How to setup the sample environment

Modified on 2007/03/07 19:48 by AlexanderZeitler Categorized as Documentation
The sample environment consists of three parts whose installation is described below :

{TOC}

==1 - .NET Framework 2.0 SDK==
To establish ADODB connections visually in SharpDevelop Reports Designer you have to install the [http://www.microsoft.com/downloads/details.aspx?familyid=fe6f2099-b7b4-4f47-a244-c96d69c35dec&displaylang=en|.NET Framework 2.0 SDK].


==2 - SharpDevelop Reports for .NET (SDR)==
Please navigate to the [Download] page, download your preferred version of SharpDevelop Reports for .NET and unzip the files to the preferred location on your computer.


==3 - SQL Server Express 2005 with SP2==
The SDR Samples require a SQL Server 2005 (Express) instance named (local)\SQLExpress.
If you already have installed an SQL Server 2005 (Express) instance named (local)\SQLExpress, you can skip this step and continue with step 3.

First, navigate to [http://msdn.microsoft.com/vstudio/express/sql/download/]. This is the location where you can download [http://go.microsoft.com/fwlink/?LinkId=65212|SQL Server Express 2005 SP2] or [http://go.microsoft.com/fwlink/?LinkId=65109|SQL Server Express 2005 SP2 with Advanced Features].

Choose your preferred option and download the file to your local computer.

===3.1 - SQL Server Express 2005 SP2===
When download has finished, run the executable (as Administrator on Vista).

First, Setup is installing the SQL Server Express 2005 Prerequisites:
[imageauto|Installing the SQL Server Express 2005 Prerequisites|{UP}Tour%2fSDRSQLServer2005Prequisites_Small.png|^{UP}Tour%2fSDRSQLServer2005Prequisites.png]

After this, Setup checks the System Configuration for potential problems:
[imageauto|Checking the system for potential problems|{UP}Tour%2fSDRSQLServer2005SystemConfigurationCheck_Small.png|^{UP}Tour%2fSDRSQLServer2005SystemConfigurationCheck.png]

Then, Setup requests the Registration Information:
[imageauto|Registration Information|{UP}Tour%2fSDRSQLServer2005SystemRegistrationInformation_Small.png|^{UP}Tour%2fSDRSQLServer2005SystemRegistrationInformation.png]

You can leave "Hide advanced configuration options" checked.

The default "Feature Selection" is ok for our demos:
[imageauto|Feature Selection|{UP}Tour%2fSDRSQLServer2005SystemRegistrationInformation_Small.png|^{UP}Tour%2fSDRSQLServer2005SystemRegistrationInformation.png]


"Windows Authentication Mode" is the correct "Authentication Mode":
[imageauto|Authentication Mode|{UP}Tour%2fSDRSQLServer2005AuthenticationMode_Small.png|^{UP}Tour%2fSDRSQLServer2005AuthenticationMode.png]

Please check "Add user to the SQL Server Administrator role":
[imageauto|Configuration Options|{UP}Tour%2fSDRSQLServer2005ConfigurationOptions_Small.png|^{UP}Tour%2fSDRSQLServer2005ConfigurationOptions.png]

The "Error and Usage Report Settings" can be set as you want them to be set.

After doing so, you can start the installation by clicking the "Install" button.

When Setup has finished installing SQL Server 2005 Express SP2 you can click the "Finish" button:
[imageauto|Finished Setup|{UP}Tour%2fSDRSQLServer2005CompletingMicrosoftSQLServer2005Setup_Small.png|^{UP}Tour%2fSDRSQLServer2005CompletingMicrosoftSQLServer2005Setup.png]

To ease administration of your SQL Server instance, you have to download [http://go.microsoft.com/fwlink/?LinkId=65110|SQL Server Management Studio Express].

After finishing the download, please run the executable, accept the license agreement and fill in your registration information.

The feature selection can be confirmed with "Next" and after that you just need to click "Install".

When setup has finished successfully, you're ready to procceed with Step 3.

===3.2 - SQL Server Express 2005 SP2 with Advanced Features===

====3.2.1 - Windows XP Pro====
Please install IIS for Windows XP Professional (screenshots will follow).


====3.2.2 - Windows Vista====
To run SQL Server Express 2005 SP2 with Advanced Features on Windows Vista, Internet Information Services are required. Due to the "secure by default" approach, IIS are not installed by default after Windows Vista installation. IIS needs to be installed by running "Turn Windows Features on or off" in the "Programs" sections of the control panel.
The options being checked in the screenshot below mark the minimum requirements for SQL Server Express 2005 SP2 width Advanced Features:

[imageauto|Minimum IIS settings for SQL Server Express 2005 SP2 with Advanced Features|{UP}Tour%2fSDRSQLServer2005AdvancedOnVistaIIS_Small.png|^{UP}Tour%2fSDRSQLServer2005AdvancedOnVistaIIS.png]


After installing IIS you can run the SQL Server 2005 with Advanced Services Setup executable (as Administrator on Vista) and act as described under 2.1 until the point "Feature Selection".

There you have to select the "SQL Server Management Studio Express" to be additionally installed with SQL Server 2005 Express.

[imageauto|Feature Selection|{UP}Tour%2fSDRSQLServer2005AdvFeatureSelection_Small.png|^{UP}Tour%2fSDRSQLServer2005AdvFeatureSelection.png]

After this, you can continue as described in 3.1. Of course, you don't need to install the SQL Server Express Management Studio after the successful installation of SQL Server 2005 Epxress.

==4 - Northwind Sample Database==
Please navigate to the [http://www.microsoft.com/downloads/details.aspx?familyid=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en|Northwind and pubs Sample Databases for SQL Server 2000] and download the files. 

When download has finished, please install the files.

Now run SQL Server Management Studio Express Edition, load the file "C:\SQL Server 2000 Sample Databases\instnwnd.sql" and click the "Execute" button in SQL Server Management Studio Express:

[imageauto|Executed Northwind Script in SQL Server Management Studio Express|{UP}Tour%2fSDRSetupNorthwind_Small.png|^{UP}Tour%2fSDRSetupNorthwind.png]
Meta Keywords:
Meta Description:
Change Comment:
SharpDevelop Reports (SDR)

Navigation¶

How to setup the sample environment
