Wednesday, August 19, 2015

Preparing off box SQL

Create a database using SQL defaults.  Database name MUST be named BOC.
Set the recovery model to SIMPLE.
Create a SQL user and give it DBO rights over that database BOC.
It must be an actual SQL user and not an AD account.
A suggested name is BOC-ADMIN to stay in line with other settings.

When you install the application and give it the connection details, the application will build the rest of the database automatically.

We do not recommend replication on it since the data turns over so quickly which can severely impact both log file and WAN links.

No comments:

Post a Comment