Installation Guide for Web Client

Step 1 — Server Prerequisites

Verify your server meets all of these requirements before proceeding:

• Microsoft IIS Web Server version 10 or above
• Microsoft SQL Express 2016 or above
• SQL Server Management Studio (SSMS)
• Microsoft .NET 4.8 or above
• Microsoft URL Rewrite Module 2.1 or above (critical — see note below)
• Microsoft Windows 10 or Windows Server 2016
• 16 GB RAM minimum
• 500 GB hard drive minimum
• 100 Mbps Ethernet or faster

Step 2 — Download the Application

Download the stweb.zip file from the downloads page or contact support for the latest version link.

Step 3 — Prepare the Application Folder

1. Create a new folder on your web server (e.g., C:\inetpub\StandardTime\).
2. Place the downloaded stweb.zip file in that folder.
3. Right-click the zip file and select Extract All.
4. Extract the contents to the same folder.
5. Optionally delete the zip file after extraction.

Step 4 — Create the Credentials File

Create a text file named exactly Standard Time SQL.dsn in your application folder. This file tells the web application how to connect to your SQL database.

The file should contain:

[ODBC]
DRIVER=SQL Server
UID=MySqlLoginName
PWD=onlyifnotwindowsauthentication
DATABASE=Standard Time
SERVER=myservername\mysqlinstancename
Trusted_Connection=Yes

Replace MySqlLoginName, myservername, and mysqlinstancename with your actual SQL Server values.

Step 5 — Create Website in IIS

1. Open IIS Manager on your web server.
2. Expand Sites in the left navigation tree.
3. Right-click Sites and select "Add Website".
4. Enter Standard Time as the website name.
5. Select or create an Application Pool.
6. Click the "..." button to navigate to your application folder.
7. Ensure "Start website immediately" is checked.
8. Click OK.

Step 6 — Create SQL Login for IIS (if separate machines)

If IIS and SQL Server are running on separate machines, you need to grant the IIS Application Pool identity access to the database.

1. Open SQL Server Management Studio.
2. Navigate to Security > Logins.
3. Right-click Logins and choose "New Login".
4. Enter IIS APPPOOL\YourAppPoolName as the login name (replace with your actual app pool name).
5. Set Standard Time as the default database.
6. Click User Mapping.
7. Check the Standard Time database and assign db_owner role.
8. Click OK.

Step 7 — Access the Website

1. Open Google Chrome or any modern browser.
2. Navigate to your server's URL (e.g., http://yourservername/ or the configured port).
3. The Standard Time® web application should load and display the login screen.

Step 8 — Troubleshooting

If you encounter database connection errors or a blank page:

1. Search for and open Event Viewer on the server.
2. Expand Windows Logs.
3. Right-click Application and clear the log if it is very large.
4. Attempt to log in to Standard Time® again.
5. Press F5 to refresh.
6. Review the new error entry in Event Viewer for the specific error message and SQL connection details.