<< 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).