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:
- The database must be installed onto any edition (Express or better) of Microsoft SQL Server (2012 or later).
- The website needs to be setup on any IIS Web Server (7.5 or later recommended) using ASP.NET MVC 4.
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).
- Unzip the contents to a folder on your computer e.g. C:\Inetpub\wwwroot\TallyJ\
- Open IIS and Add Application or Convert to Application to add the folder to the web server.
- For the Application Pool, select .NET v4.5 if available or .NET v4.0 in Integrated mode.
- 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.
- 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"
As of version 2.5, session state is now stored inside the database by default.
- You can change this by making adjustments in the web.config file.
- Test the website. The initial page can be displayed without the database, but other pages rely on it.
- This is a definition file that tells Microsoft SQL how to setup the database.
- To use, open SQL Server Management Studio, right click on Databases and select Deploy Data-tier Application.
- 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.
- Once complete, the database should be created with the necessary tables.
- 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).
- 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.
- 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.
Updating to the latest version of TallyJ 2
- When Glen publishes a newer version, it usually includes just changes to the website.
- Download the new TallyJ.Web.____.zip
- Make a copy of your current web.config file.
- Unzip the contents of the new version over top of the previous files, replacing everything.
- Once done, copy your backed up web.config file back, replacing the file already present.
- First refer to this document for general information
- Edit the config file and change the binding information to include: *:80:serverName
- Run the following in an elevated CMD prompt:
netsh http add urlacl url=http://serverName:80/ user=everyone