Configure the Web Service Component

By default, the web service is installed in the local host of the computer where the Connected Business is installed. During installation, the user can specify the website where the web services will be installed provided that the website must be running on the machine’s Microsoft IIS (usually set to Default Website). The user can also specify in the local host where to install the web services.

Prior to connecting to the internet, the web service component, Business Service, must be configured appropriately from the installation. You may install the Business Service on a server that allows remote connection through the internet outside the office.

Install Connected Business Client Application

For a step-by-step demonstration, consult our documentation: Download Connected Business Installer.

Install Connected Business Components – Client / Server Only

Before installing Connected Business, the system requires you to install SQL Server Management Studio, as well as MS SQL Server 2008 R2 or SQL Server Express 2012 or their latest versions. 

ConsultInstall Connected Business Components – Client / Server Only and follow the steps for installation. If you don't have SQL express already installed in your work station, select the second option ("Install MS SQL Server 2008 R2 Express Edition on this local computer") in the Installation wizard.

Click Image to Enlarge

Back to Top

Connect to Hosted Database Using Web Services

  1. Before attempting to connect to your hosted database, make sure that you have the correct web services URL, username, and password. Ask your hosting department or web administrator for these details.

  2. Open the Connected Business Client application. On the sign-in field, click Change or Press F2 to load the Configuration Tool.

    Click Image to Enlarge

  3. When the Configuration Tool is displayed, click on New button to create a new company setup. The new setup will appear on the left side of the screen. Change the default company name according to your preference.

    Click Image to Enlarge

  4. Click on the Connection field to activate the dropdown menu. Choose the setting labeled Use Internet Connection Only.

    Click Image to Enlarge

  5. In the Business Service URL field, paste the Web Service URL provided to you by your web administrator. Click Test and wait for the prompt that says Connection Succeeded. If Connected Business cannot connect to your web service URL, a prompt will appear stating that the connection has failed.

    Click Image to Enlarge

  6. Configure the Cache Database connection by clicking on the button with the ellipsis (…) to open the Database Connection dialog box.

    Click Image to Enlarge

  7. On the Database Connection dialog box, fill in the relevant information such Server Name or SQL Instance, Login Authentication Type, User ID, and Password. Click the Test Connection button. If the connection succeeds, click OK.

    Click Image to Enlarge

  8. Click on Save and Close button to save the company settings.

  9. Back in the Connected Business sign-in page, click on the text above the user code field to select your Company Setup.

    Click Image to Enlarge

  10. Provide the user name and password. Click the arrow button or press Enter to sign in to the application.

  11. The Cache Manager will appear, displaying the progress of the caching process.

    Click Image to Enlarge

    When the process is finished, the screen will display the Connected Business dashboard.

Back to Top

Configure Web Service Virtual Directory

IIS 5.x/6.0

If you are using an operating system with an IIS 5.x / 6.0, make sure to enable IIS 6.0 to run with 32-bit application on 64-bit windows by following the steps below:

a. Open a command prompt and navigate to the %systemdrive%\Inetpub\AdminScripts directory

b. Type the following command: cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 "true"

c. Press ENTER.

To configure the web service virtual directory for IIS 5.x / 6.0,

  1. Open the IIS Manager by navigating to Start ► Control Panel ► Classic View ► Administrative Tools. Double click on the Internet Information Services (IIS) Manager shortcut icon or you can type the keyword "inetmgr" directly on the search field of the Start menu.
  2. On the left pane of the IIS Manager, click on the localhost to expand the link. Click on Sites ► Default Web Site.
  3. Right-click on the virtual directory you want to configure (e.g. InterpriseSuiteWSBusiness), and select Properties. Under the Virtual Directory tab ► Application Settings section, make sure that the Application name is filled in/created.
  4. In a 64-bit windows version, click on the Web Service Extensions, then make sure that the ASP.NET v2.0.50727 (32 bit) extension status is set to Allowed (right click on the extension then select Allow from the option).

    If the ASP.NET v2.0.50727 (32-bit) option is not available in the list of Web Service Extensions, follow the steps below. Avoid using special characters or symbols such as apostrophes or plus sign.

    a. Open a command prompt and navigate to the %systemdrive%\Windows\Microsoft.NET\Framework\v2.0.50727 directory.

    b. Type the following command: aspnet_regiis -i

    c. Press ENTER. then do step #4.

  5. Right click on the InterpriseSuiteWSBusiness, select the group or user name. For this setup, we need to add the ASP.NET and NETWORK SERVICE accounts on the list.
  6. In the Permissions list, set the appropriate permissions for the group or username. Click OK.
  7. You should now be able to browse the business service without error. Right click on the InterriseSuiteWSBusiness then select Browse from the option.
  8. The next step is to establish the database connection.

IIS 7.0 / 7.5

To configure the web service virtual directory for IIS 7.0/7.5,

  1. Open the IIS Manager by navigating to Start ► Control Panel ► Classic View ► Administrative Tools. Double click on the Internet Information Services (IIS) Manager shortcut icon or you can type the keyword "inetmgr" directly on the search field of the Start menu.
  2. In the IIS Manager, right click on the virtual directory you want to configure (e.g CBWEBSVC) and select Edit Permissions. Alternatively, you can select the virtual directory and click on Edit Permissions in the Actions panel. The Business Properties window will be displayed.
  3. Go to Security tab ► Edit and the Permissions for Business window will be displayed.
  4. Click on Add and enter the name of the user or group to add in the list of authenticated users. Click OK. You can also click the Advanced button to search for specific group or users.
  5. Set the permission rights for the selected group or user by ticking the appropriate checkboxes from the Permissions for Authenticated Users section.
  6. Click Apply and OK to save changes in the Permission for Business window.
  7. Click Apply and OK to apply changes in the Business Properties window.

To enable Connected Business to run on a 64-bit version of windows, follow the steps below.

  1. Under the Default Web Site folder, right-click on CBWEBSVC and select Manage Application ► Advance Settings.

    Click Image to Enlarge



  2. In the Advance Settings window, click the ellipsis button next to the Application Pool field and select ASP.NET v4.0 app pool from the dropdown list. Click OK to apply changes.

    Click Image to Enlarge

  3. Click the Application Pools on the right panel. Right-click on the ASP.NET v4.0 AppPool from the Applications Pools list and select Advance Settings.

    Click Image to Enlarge

  4. In the Advance Settings window > General section, set Enable 32-Bit Application to True and under Process Model section, set Identity to Network Service. Click OK to apply the changes.

    Click Image to Enlarge

  5. Set Anonymous Authentication to use application pool identity. Click on the server name and under IIS, double click on Authentication.

    Click Image to Enlarge

    Right click on Anonymous Authentication and select Edit.

    Click Image to Enlarge

    The Edit Anonymous Authentication Credentials window will be displayed. Tick the Application pool identity radio button and click OK.

    Click Image to Enlarge

  6. Right click on the web service directory e.g. CBWEBSVC, and select Manage ApplicationBrowse. Alternately, you may click on Browse in the Actions panel.

    Click Image to Enlarge

  7. The default browser will display the list of operations being supported by the Connected Business Service.

    Click Image to Enlarge

Back to Top

Establish Web Service Database Connection

To establish the web service database connection,

  1. Open the Connected Business Application Configuration Tool by navigating to StartAll ProgramsConnected Business 13.2 ► Tools ► Connected App Config 13.2.
  2. Locate and open the Connected Business Web Service web.config file by clicking FileOpenConfiguration File. By default, this is located at C:\Program Files\Connected Business\Connected Business13.2\WebService\Business.

    Click Image to Enlarge



  3. In the App Config window, set the Connection Protocol to Use LAN Connection Only.

    Click Image to Enlarge



  4. In the User Account section, enter the user code and password. By default, the user code and password are set to webadmin.

    Click Image to Enlarge

    A default user account “webadmin” is created as dedicated user for the web service account in order to avoid error such as “You are signed in to another computer. Please logout from Computer <HostName> to continue”.

  5. Set the database connection by clicking the ellipsis button inside the company database name. The Database Connection window will be displayed. In the Server Name field, indicate the SQL server instance where the database is installed. (e.g. RemoteServerName\SQLEXPRESSCB13) or select from the list of servers detected by Connected Business.

    Click Image to Enlarge

  6. After indicating the server name,select the login authentication to use.
    • If using SQL Server Authentication, provide the User Name and Password. Click the Test button to test the connection. Click OK to apply the changes.
    • If using Windows Authentication, click the Test button to test the connection. Click OK to apply changes.
  7. Select the Default Web Store to use for the web service connection.

    Click Image to Enlarge

  8. After defining the configuration for the web service, click Set as Default from the menu and Save and Closeto apply the changes.

Back to Top

 

  • Tuesday, 31 July 2012