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="" />