...
- 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.
...
- Log on to the server
- bitB can use Windows Authentication or SQL Server Authentication.
- bitB can use Windows Authentication or SQL Server Authentication.
...
- Windows Authentication is used for a local Microsoft SQL Server or local Microsoft SQL Server Express installation.
...
- 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.
...
- Enter the user name and password.
...
- For SQL Authentication, enter the username and password form the local or remote installation.
...
- No Username and Password is required for Windows Authentication. The logged in user ID and password are used.
...
- Initial catalog to use (Database Name)
...
- Enter the name you used to create the bitB database. The default name is bitB.