Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Define the SQL database connection properties.

    bitB requires a database to store run-time data.   You need to specify:

    Server Name:  Host\SQL_Instance:Port

    You may need to consult your database administrator to determine the correct values.

    If the database is on the local machine, you can enter (Local) in the Host field.

    For a remote server, set Host to the IP address.

    If you are using Microsoft SQL Server express, you can enter SQLEXPRESS in the [\instance] field.  If you are using Microsoft SQL   Server, you can enter MSSQLSERVER.

  2. Log on to the server

    bitB can use Windows Authentication or SQL Server Authentication.

    1. Windows Authentication is used for a local Microsoft SQL Server or local Microsoft SQL Server Express installation.

    2. SQL Server Authentication can be sued for local or remote SQL Server databases.  Note:  SQL Server and Windows Authentication mode must be enabled on the system hosting the bitB database.
  3. Enter the user name and password.

    1. For SQL Authentication, enter the username and password form the local or remote installation.

    2. No Username and Password is required for Windows Authentication.  The logged in user ID and password are used.

  4. Initial catalog to use (Database Name)
    Enter the name you used to create the bitB database.  The default name is bitB.