User Manual

08.14.2024

MANUAL

FAQ: 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](/en/manual/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](/ja/manual/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) ```json { "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 } ``` ## Related Information <div id="ManualList"> <article class="s-blog_list_unit"><h2> <h2>The specified information was not found.</h2> <p><a href="/ja/manual">Return to top</a></p> </article> </div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.