TallyJ 2 Offline Installation

N.B: Whilst it may be possible in the future to make the installation of TallyJ 2 more seamless and automated, as of now it needs to be setup manually and for this there are a specific set of requirements that need to be met:

TallyJ 2 is composed of two “parts” - a website and a database.

You can download these files from this Google Drive (please request access from Glen if you need it).

TallyJ.Web.2._____.zip

  1. Unzip the contents to a folder on your computer e.g. C:\Inetpub\wwwroot\TallyJ\
  2. Open IIS and Add Application or Convert to Application to add the folder to the web server.
  3. For the Application Pool, select .NET v4.5 if available or .NET v4.0 in Integrated mode.
  4. If not installed in the "Inetpub" folder, ensure that the IIS Application Pool assigned has access to read files from the directory containing these files.
  5. If you do not have the ASP.NET State Service running on the computer, you may need to adjust the  <sessionState> setting in the web.config and change it so that it reads: mode="InProc"
  6. Test the website. The initial page can be displayed without the database, but other pages rely on it.

TallyJ._____.dacpac

  1. This is a definition file that tells Microsoft SQL how to setup the database.  
  2. To use, open SQL Server Management Studio, right click on Databases and select Deploy Data-tier Application.
  3. Follow the prompts of the wizard until complete (use the default values or customise as needed) and when prompted for a DAC package to deploy, select the .dacpac file to upload.
  4. Once complete, the database should be created with the necessary tables.
  5. Finally add a user to the database (e.g. IIS AppPool\TallyJ where “TallyJ” is the name of the AppPool) and set this user as the owner of the database (this ensures the AppPool can read and write to the database).
  1. To add a user, expand the database just created (in this case TallyJ2d), go into the Security > Users folder, right click on Users and select New User.
  2. To set a user as an owner of a database, go into the Membership page of the user properties, and check the box labelled db_owner.

Providing your SQL Instance is called SQLEXPRESS, then TallyJ 2 should be working at this stage. If your SQL instance is called something else, then you will need to adjust the connection string in the web.config file to match your instance.


Further Tips