This page is for the Pegasus Opera II or 3 pacakge using the Microsoft SQL Server Database Engine. This edition doesn't cover the Visual FoxPro configurations.

Please follow steps below to configure your Opera company to the Open Accounting Connector application.
Click each step below for a pictorial view

Now that the application is installed please double click the Open Accounting Connector desktop shortcut. Some configuration details are required to connect to your Opera Company. These details can be found in Opera. Please open your Company in Opera, in the Ribbon above goto 'Administration' > 'Maintenance' > 'Company Profile' - see an example on the right. Server Name: On the right this is the field in Green. This is the Server Name the database is held on including the instance name in format "ServerName/InstanceName" exactly as seen in Operas Company Profiles Window. Database: On the right this is the field in Orange. Please enter the database name as seen in Operas Company Profiles Window. User / Password: These are the SQL Authentication credentials taht is mapped to your Opera database. This may require consulting IT to create/supply a user. Now click Finish and Extract to submit your first data load!

Your Open Accounting Connector application may be setup to retrieve data automatically at a predefined schedule, this functionality relies to be logged on at the scheduled time. Due to the nature of Servers, it may rarely be logged into. So if the Open Accounting Connector application is installed on a Server, extractions may not always perform automatically. To enable this feature a task scheduler would have to be created.
To create a task scheduler please go to the installation path of Open Accounting Connector, usually held in C:\Open Accounting Connector_xxx\ Open the taskSchedule.bat file and follow the instructions.

An MSSQL user can be created dedicated to the Open Accounting Connector application. This user should be created and mapped to the desired database with db_readonly rights as a minimum requirement.
Click each step below for a pictorial view

Open Microsoft SQL Management Studio and connect to the Database Engine. Now expand the Security folder in the Object Explore and right-click Logins to create a New Login. Within the General page please create a username with SQL Server Authentication Remove the defaulted Enforced password policy (so the user doesn't expire). Now navigate to the User Mapping page to give the user rights to the database. Tick the database name in the top half panel, and give the user db_readonly rights (as a minimum requirement) in the bottom half panel.

If after clicking the Test Connection button an error message appears it is most likely that one (or more) of the credentials entered are incorrect. Below are a few examples of the typical errors and how to handle them:

• Incorrect username/password:
  
  If this error appears, the SQL Server username or password is incorrect ? remember the username and password required to Pegasus Opera is the SQL Server username and password not the username and password required to log into Pegasus Opera.


• Incorrect Server/ Server not located:
  
  

  If this error appears the Server isn?t able to be located. This could be due to a number of reasons.

  • The server might be turned off
  • The server may not be on the same network as the same PC Open Accounting Connector is running from
  • The PC Open Accounting Connector is running from may not have access to that server
  • The server may have an instance that the database (that Opera is using) is located on.
  • The server may be using a different TCP/IP
  • There might be spelling error


• Incorrect Instance:
  
  

  If the instance used is incorrect or not entered (only if one exists). Please double check Opera's Company Profiles Window - Step 2 above

• Unknown Server Hostname:
  
  

  If the Server Name entered is incorrect please double check Opera's Company Profiles Window - Step 2 above.

• Cannot Open Database:
  
  

  The SQL user entered must be mapped to the companys database. Please see the advanced section on how to give a user read only access in Microsoft SQL Server Management Studio.