...
- 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.- 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.
- Windows Authentication is used for a local Microsoft SQL Server or local Microsoft SQL Server Express installation.
- 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.
- For SQL Authentication, enter the username and password form the local or remote installation.
- Initial catalog to use (Database Name)
Enter the name you used to create the bitB database. The default name is bitB.