Page Comparison

...

1. Create a database for TermWeb to store data in (e.g. termweb). 
   
   • Open pgAdmin and right click on Databases and select New Database
     Encoding: UTF8
     Template: template0
     Collation: C
     Character Type: C
     
     
2. Create a database login role (user) which TermWeb will connect as (e.g. termwebuser), with permissions for the database.
   • Create a new login role (right click on SecurityLogin Roles and navigate to select New > Login Role) and name it termwebuser. Select SQL Server Authentication and enter a password for the userSelect password: termwebuser.

   • Create a user for the database (right click on Security under termwebdb and navigate to New > User) and name it termwebuser. Enter termwebuser as Login name, then select Membership page and select the rolesdb_datareader, db_datawriter and db_owner.
     
     

3. Ensure that TCP/IP is enabled on SQL Server and listening on the correct port (which is 1433 for a default SQL Server installation).
   • Run SQL Server Configuration Manager and navigate to SQL Server Network Configuration > Protocols for MSSQLSERVER
   • Check that the port is open in any firewall between TermWeb and SQL Server
      
4. Ensure that SQL Server is operating in the appropriate authentication mode. 
   • By default, SQL Server operates in 'Windows Authentication mode'. However, if your user is not associated with a trusted SQL connection, i.e. 'Microsoft SQL Server, Error: 18452' is received during TermWeb startup, you will need to change the authentication mode to 'SQL Server and Windows Authentication mode'. In SQL Server Management Studio, right-click on the server and navigate to Properties > Security to change the authentication mode.
     
     
5. Execute the termweb_sqlserver.sql file from the installation package to create the database tables.
   • If you named the database something else than termwebdb, first edit the file and enter the database name in the first statement.
   • In SQL Server Management Studio, navigate to File > Open > File and select the file.
   • Right-click and select Execute, or just press F5 to run the script.
     
     

...