Connecting TermWeb to SQL Server 2012

These instructions will help you connect TermWeb to a Microsoft SQL Server 2012 database.

1. Create and Configure the SQL Server Database

1. Create a database for TermWeb to store data in (e.g. termwebdb). 
   
   • Open SQL Server Management Studio and right click on Databases and select New Database
     
     
2. Create a database user which TermWeb will connect as (e.g. termwebuser), with permissions for the database.
   • Create a new login (right click on Security and navigate to New > Login) and name it termwebuser. Select SQL Server Authentication and enter a password for the user.

   • 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 roles db_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
   • (File -> Open -> File, right click >Execute)