Header Image

Setup Guide: Installing the Integrated Business Applications software on Microsoft IIS 7.5 and Microsoft SQL Server 2008.

This article walks you through installing the Integrated Business Applications software on Microsoft IIS 7.5 (Windows Server 2008 R2) and Microsoft SQL Server 2008.

Terms of Use

This document is provided under the terms outlined in the Integrated Business Applications End User License Agreement.

If you do not understand, accept and agree to be bound by the End User License Agreement, do not use this document or any of the procedures discussed herein.

You should read this document from beginning to end before proceeding with the procedures or steps discussed and or outlined.

Please report any errors and or omissions by e-mailing our Technical Support Team at service@ascs.ca.

Audience

This document in designed for the technician that will be installing the Integrated Business Applications software. It is assumed that this person has a working knowledge of Microsoft Windows Server, Microsoft SQL Server and Microsoft IIS Web Services as well as experience configuring each.

Instructions and Screenshots

The Instructions and screenshots presented within this document are based on Microsoft SQL Server 2008 (SQL Server 10.50.1617) and Microsoft IIS 7.5 (Windows Server 2008 R2 Enterprise). The Integrated Business Applications software, however, will run on various versions of the Microsoft Windows and SQL Server. See Install Requirements for additional details.

Installing and Configuring the Integrated Business Applications Database

The following section outlines how to create an empty database that will be used by the Integrated Business Applications software.

Creating the Database

Launch the Microsoft SQL Server Management Studio and connect to your database server (See Figure 1).
Figure 1
Figure01
Right click on the databases tab and select New Database from the pop up menu (See Figure 2).
Figure 2
Figure02
The new database may be named anything you wish. Its recommended, however, that the database be named IntegBus.

NOTE: The necessary SQL database tables will be created later in the installation process. The tables are created using the Integrated Business Applications setup utility - discussed later in this document.

Configuring the Database User Account

Using the Microsoft SQL Server Management Studio, right click on the security tab and create a new user login (See Figure 3).
Figure 3
Figure03
This login will be used by the Integrated Business Applications software to access the database - created in the steps above.

The new login must use SQL Server Authentication (See Figure 4).
Figure 4
Figure04
Next, select the User Mapping tab and map the new user account’s permissions to the database. The user will require the public and db_owner permission (See Figure 5).
Figure 5
Figure05
NOTE: Security can be tightened after the installation is complete by restricting the login account (used by the application) to db_datareader, db_datawriter and db_backupoperator.

The db_owner role, however, will have to be added back when applying updates to the system. The Integrated Business Applications setup utility requires this role to extend the database schema.

Installing the Integrated Business Applications software Files

The following section explaines how to install the Integrated Business Applications software files.

Creating the Application Folder

Create an empty folder on the server’s disk drive to hold the Integrated Business Applications application files. It is recommended that this folder be placed at the root of the disk drive for easy location and access. It’s also recommended that this folder be named IntegBusApp (See Figure 6).
Figure 6
Figure06

Creating the IIS Application

Launch the IIS Services Manager. The Services Manager will be used to create the IIS Application that will host the Integrated Business Applications application files (See Figure 7).
Figure 7
Figure07
Once the IIS Services Manager is loaded, right click the website in which you wish to place the Integrated Business Applications application and select Add Application from the popup menu.

Enter an Alias and Physical Path for the application. The Physical Path will be the empty folder created on the server’s hard disk in the previous step. The Alias may be any name you wish. It's recommended that the Alias be named IntegBus (See Figure 8).

The Integrated Business Applications application files will be added in a subsequent step.
Figure 8
Figure08

Creating the IIS .NET 4.0 Application Pool

Right click on the Application Pools tab (See Figure 9).
Figure 9
Figure09
Select Add Application Pool from the pop up menu and complete the dialog box to create a new .NET 4.0 Framework application pool. Be sure to set the .NET Framework version to “.Net Framework v4.0.30319”. It's recommended that the pool Name be set to IntegBus (See Figure 10).
Figure 10
Figure10

Attaching the .NET 4.0 Application Pool to the Integrated Business Applications Application

Right click the newly created Integrated Business Applications application tab (under the website where you placed the application) and select Manage Application and then Advanced Settings (See Figure 11).
Figure 11
Figure11
Use the dialog box to change the Application Pool to the .NET 4.0 application pool created in the previous step (See Figure 12).
Figure 12
Figure12

Setting the IIS Application .NET Globalization

Right click the newly created Integrated Business Applications application tab (under the website where you placed the application) and double click the .NET Globalization Icon (See Figure 13).
Figure 13
Figure13
Change the Culture and UI Culture settings to English (United States) (en-US). Now, click the Apply link located on the far right menu (See Figure 14).
Figure 14
Figure14

Installing the Integrated Business Applications Application Files

Extract the ZIP file containing the Integrated Business Applications application files to your desktop (See Figure 15 and 16).
Figure 15
Figure15
Figure 16
Figure16
Copy the extracted files to the Integrated Business Applications application folder. This is the empty folder that was created at the root of server's hard disk (See Figure 17).
Figure 17
Figure17

Editing the Web.Config Application Setting File

Right click the Web.Config settings file (located in the root of the Integrated Business Applications application folder) and select open from the pop up menu (See Figure 18).
Figure 18
Figure18
Open the file using Notepad (See Figure 19).
Figure 19
Figure19
Be sure to use Notepad. Never use a text editor like Microsoft Word or Open Office to edit the Web.Config file as these editors may corrupt the configuration file.
Edit the following parameters in the Web.Config file:
  • IntegBusSQLServer

    Address of the SQL database server on which the SQL database is hosted. This may be an IP address or fully qualified domain name.
  • IntegBusSQLDatabase

    Name of the Integrated Business Applications SQL Server database.
  • IntegBusUserID

    User ID used by the Integrated Business Applications application to connect to the SQL server database.
  • IntegBusPassword

    Password used by the Integrated Business Applications application to access the SQL server database.
  • IntegBusSetupUserID

    User ID used to access the setup utility (discussed later in this document).
  • IntegBusSetupPassword

    Password used to access the setup utility (discussed later in the document).
The following parameters are discussed in other Integrated Business Applications documentation and may be safely ignored for now.:
  • IntegBusBackupLocationEditing
  • IntegBusImportFolderEditing
  • IntegBusSupportFolderEditing

Extending and Validating the SQL Database Schema

The following procedure populates the Integrated Business Applications database with the tables required for the system to operate, and then confirms the schema has been extended as required.

Extending the Database Schema

Its recommended that the Extend Database Schema task be executed using the host server’s web browser. Using the host server’s web browser will allow errors (should one occur) to be displayed directly in the web browser.

Launch the Integrated Business Applications setup utility by entering the following address into your web browser’s address bar:

http://YourSiteAddress/setup/setup.aspx

Replace “YourSiteAddress” with the actual address of your site.

The following page (See Figure 20) should be displayed:

Figure 20
Figure20
As displayed in the previous image, enter the utility’s User Name and Password and then select Extend Database Schema from the dropdown menu.

The User Name and Password used in this screen are those entered in the Web.Config file:
  • IntegBusSetupUserID

    User ID used to access the setup utility.
  • IntegBusSetupPassword

    Password used to access the setup utility.

After running the Extend Database Schema task, the screen will refresh and display Task Complete; as shown in the following image (See Figure 21).
Figure 21
Figure21

Validating the Database Schema

The following procedure validates the Integrated Business Applications SQL Database schema.

Launch the Integrated Business Applications setup utility by entering the following address into your web browser’s address bar:

http://YourSiteAddress/setup/setup.aspx

Replace “YourSiteAddress” with the actual address of your site.

The following page (See Figure 22) should be displayed:
Figure 22
Figure22
As displayed in the previous image, enter the utility’s User Name and Password and then select Generate Database Schema Report from the dropdown menu.

  • IntegBusSetupUserID

    User ID used to access the setup utility.
  • IntegBusSetupPassword

    Password used to access the setup utility.
The Generate Database Schema Report task will generate a list of all the tables contained in the Integrated Business Applications database. A sample of the report is shown below (See Figure 23).
Figure 23
Figure23
Additional Information
Please use this link to reach out to us; we are always happy to answer your questions.
 
© Integrated Business Applications
All Rights Reserved
End User
License Agreement (EULA)
Website
Terms of Use
© Integrated Business Applications
All Rights Reserved




End User
License Agreement (EULA)




Website
Terms of Use