Settings SQL server connection

<< Click to Display Table of Contents >>

Navigation:  Manage ledgers (administrations) > Connection accounting package >

Settings SQL server connection

Menu items: 'Administration', 'Bookkeeping'

To connect to a SQL server database, open the window 'Bookkeeping' and select the appropriate accounting package.

Then enter the following information to complete the configuration:

Server

Enter the IP address or name of the SQL Server used by the accounting package. Push the button 'Servers...' for a list of available SQL servers

Username and password

Enter the username and password of a user that is allowed to read information from the database of the ledger (administration) in the accounting package.

Database

Enter or select the name of the database in which the financial ledger (administration) is stored (this setting is not always required).

DBOwner

In some cases the DBOwner information is required to connect to the database. This information can be provided by the database administrator.(This setting is not always required)

Administration

Enter the name of the administration that must be imported. (This setting is not always required).