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](/en/manual/getting-started-pleasanter-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"><ul><li><a href="/en/manual/getting-started-pleasanter-windows">Install Pleasanter on Windows</a><span>10.01.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />