Manual d-basics

Settings SQL server connection

Hide Navigation Pane

Settings SQL server connection

Previous topic Next topic  

Settings SQL server connection

Previous topic Next topic JavaScript is required for the print function  

Menu options: 'Administration', 'Bookkeeping'

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

Then enter the following information to complete the configuration:

 

Server

Enter the IP address or name of the SQL Server used by the accounting program. 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 accounting administration.

 

Database

Enter or select the name of the database in which the financial 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).