Requirements to run SQL Server on a separate server than the bitB Server

Here are the SQL Server requirements for bitB when the bitB Database is hosted on a server separate from the bitB application server.

Requirements

Security

1. Please verify that TCP Port 1433 is accessible between the bitB Server and the SQL Server, as the bitB Server will be initiating connections to the SQL Server.

SQL Server Configuration

1. Create a SQL Database named bitBServer

2. Establish an SQL Administrator (sa) account on the SQL Server, as it's necessary for the bitB Server to have both read and write access to the bitB database.

3. The sa account must have these permissions:

   1. Security>Logins:

      1. Login Properties:

         1. Server Roles: Public

         2. User Mapping

            1. Users mapped to this login: Database: bitBServer

            2. Database role membership for: bitBServer

               1. db_owner

               2. public

         3. Securables

            1. Explicit

               1. Permission: Connect SQL Grantor: sa Grant: <Selected>

   2. Databases>bitbServer>Security>Users>
      Membership:
      Role Members: db_owner