Skip to content

I want to build a web server and a database server on separate servers.

Answer

Please set the IP address or hostname of the database server in the Server keyword of the connection string of the parameter "Rds.json".

Overview

This is a setting method for building a web server and a database server on separate servers. This FAQ uses Windows/SQL Server as an example, but the same method can be used in a Linux/PostgreSQL environment.

Configuration Example

Server A: Web server

  • IIS
  • Pleasanter

Server B: Database Server

  • SQL Server 2019 Express with Advanced Services

Setting Method

When editing "Rds.json" in the procedure "Installing Pleasanter on Windows", set the connection string to connect to Server B: Database server.

Example Of Settings (Server B is 192.168.1.10)

{
    "Dbms": "SQLServer",
    "Provider": "Local",
    "SaConnectionString": "Server=192.168.1.10;Database=master;UID=sa;PWD=SetSaPWD;Connection Timeout=30;",
    "OwnerConnectionString": "Server=192.168.1.10;Database=#ServiceName#;UID=#ServiceName#_Owner;PWD=SetAdminsPWD;Connection Timeout=30;",
    "UserConnectionString": "Server=192.168.1.10;Database=#ServiceName#;UID=#ServiceName#_User;PWD=SetUsersPWD;Connection Timeout=30;",
    "SqlCommandTimeOut": 0,
    "MinimumTime": 3,
    "DeadlockRetryCount": 4,
    "DeadlockRetryInterval": 1000,
    "DisableIndexChangeDetection": true
}