Profitbase Studio / Server and SQL Server dependencies

Profitbase Studio / Server is using parts of the SQL Server API directly, so it is required that these components are installed on the same computer as the Profitbase Studio and/or Profitbase Studio Server. Although these requirements are listed in the System Requirements document, they may from time to time (using clever ninja tactics) avoid attention from people setting up the system.

So a quick recap of the SQL Server dependencies for Profitbase Studio / Server;

When PB Studio / Server is running on the SQL Server 2005 Platform
Install SSMS 2005 OR install Microsoft SQL Server 2005 Management Objects Collection which is a part of the SQL Server 2005 Feature Pack.

When PB Studio / Server is running on the SQL Server 2008 Platform
Install SSMS 2008 OR install Microsoft SQL Server 2008 Management Objects whis is a part of the SQL Server 2008 Feature Pack.

Extracting MSI files from the installer .exe

Profitbase software is normally installed by running an installer .exe-file. The .exe-files act as bootstrappers for reading the content of the .MSI-file, checking if the required version of the Windows Installer is installed on the system, and then launches the .MSI that takes care of the actual installation of the product.

If for example you want to install the product using Group Policy deployment, you need to extract the .MSI from the .EXE. A way to do this is using the UniversalExtractor tool. This tool extracts the .MSI-file (along with other files as well) from the .EXE-file to a folder of your choice.
Once the .MSI-file is extracted, you can run it directly or use the Windows Installer tool (MSIEXEC.exe) from the command prompt to do additional actions. To get a list of your options with the Windows Installer tool, simply open a command prompt and type “MSIEXEC”

Trobleshooting Profitbase Server startup failure

When the Profitbase Server fails to start, there are a few simple steps to follow in order to resolve or narrow down the issue.

  1. Open the event viewer and look in the Application and Profitbase event logs. A clue to what the problem can nearly always be found there.
    The event log will almost certainly list one of the following reasons for the pb server not starting:

    a) The user account that the windows service is running under does not have permissions to log on to the SQL Server / database it is set up to connect to. When the PB Server is installed, it will automatically use Local System Account, which may not always have the required premissions. To change the user account the service is running under, right click the service and select -> Properties -> Log On.
    To view or edit which SQL Server instance the pb server is connected to, open the PBMSServer.exe.config in the server install folder.

    b) You may see an error message stating something similar to “Only one usage of each socket address (protocol/network address/port) is normally permitted”.
    This is usually caused by the fact that there are other Profitbase Servers running on the same machine.
    If the port number is in the 4000-range (usually 4028), you can edit PBMSServer.exe.config and change the TCPPort setting value to for example 4029.
    If the port number is in the 8700-range (usually 8700), you can edit the CommandShellServices.exe.config-file and change the port numbers in the URI’s to for example 8701.If there are no other PB Servers running on the same machine, changing the ports may still help since they may be in use by other programs.

  2. When you attempt to start the service, you may get an error message stating that the service failed to start due to a timeout. This typically happens on machines where there’s no internet connection. This is caused by a security mechanism in the .NET Framework, but it can be resolved by using the workaround described in this profitbase forum post http://community.profitbase.com/viewtopic.php?f=10&t=105&sid=9c5b70a809043d4f8e08c9907c90f1fb or at Microsoft http://blogs.msdn.com/dtjones/archive/2006/08/23/714738.aspx