...
Use the Add Database Connection Properties screen to define the SQL database connection properties.
- Define Define the SQL database connection properties.
bitB 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 Log on to the server
bitB can use Windows Authentication or SQL Server Authentication.
aa. Windows Authentication is used for a local Microsoft SQL Server or local Microsoft SQL Server Express installation.
bb. 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 3. Enter Enter the user name and password.
a a. For SQL Authentication, enter the username and password form the local or remote installation.
b b. No Username and Password is required for Windows Authentication. The logged in user ID and password are used.
4 4. Initial Initial catalog to use (Database Name)
...