...
A "SQL Server does not exist or access denied" message during installation indicates that SQL. Server is not installed or SQL Server is not running locally on the system. You will need to manually install bitB if the installer can't find an active local install of Microsoft SQL Server or if SQL Server or if SQL Server is installed remotely.
Database Connection Properties
Use the Add Database Connection Properties screen to define the SQL database connection properties.
- 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.
a. Windows Authentication is used for a local Microsoft SQL Server or local Microsoft SQL Server Express installation.
b. 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.
a. For SQL Authentication, enter the username and password form the local or remote installation.
b. 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.