Sample tasktServer Deployment using IIS
tasktServer is a .NET Core Application, using React for UI Rendering and SQL Server for data storage. This guide assumes some level of technical knowledge and is a work in progress. We will be creating a new IIS site and then deploying the application manually.
Download Latest tasktServer Alpha Binaries
- https://github.com/saucepleez/tasktServer/releases/download/0.0.0.3/tasktServerBinaries.zip or build from source
Download and install SQL Server 2017
Download and install SQL Server Management Studio (SSMS)
Download and install .NET Core 2.2 Windows Hosting Bundle
- Open Server Manager > Open IIS > Right-Click "Sites" > Select "Add Website"
- Press "OK" to create the site
Copy tasktServer Files to Folder Indicated in 'Add Website" Step
- Right Click Server Name and Select 'Explore'
- Copy tasktServer Alpha Binaries Files to Folder
- Confirm Permissions on Parent Folder for IIS_IUSRS - if it is missing then create it with indicated permissions.
-
Enable SQL Server Authentication (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-2017)
-
Create SQL User (https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user?view=sql-server-2017)
-
Example: CREATE LOGIN tasktApp WITH PASSWORD = 'pass@123'; CREATE USER tasktApp FOR LOGIN tasktApp;
-
Right-Click 'DatabaseName' > Properties > Permissions > Grant roles to ID
-
Confirm TCP Remote Access is enabled
See https://github.com/saucepleez/tasktServer/blob/master/Scripts/taskt-db.sql to create the required tables
{
"Logging": {
"LogLevel": {
"Default": "Warning"
}
},
"AllowedHosts": "*",
"ConnectionString": "Server=LOCALHOST\\SQLEXPRESS;Database=taskt;User Id=tasktApp;Password=pass@123;"
}
After this has been completed, you should now have a running copy of tasktServer!
