...
- 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
- Open pgAdmin and right click on Databases and select New Database
- 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 Login Roles and select New Login Role) and name it termwebuser. Select password: termwebuser.
- Set login role as database owner and set permissions (right click on
termwebdatabase and select Properties). Select termwebuser as owner.
- 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
- 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.
Execute thetermweb_sqlserverpostgresql.sqlfile from the installation package to create the database tables.- If you named the database something else than
termwebdbtermweb, 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.
- If you named the database something else than
...