This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.

Add the new data source in Sage 200 System Administration:

1. Open 'System > Administration > Information Management > Data Sources'.
2. Right click and select ‘Add New Data Source’.
3. Enter the data source name.
4. Click the Browse button
5. Enter the SQL Server Properties for the data source.
6. Copy the Connection String.

   Note: The Connection string contains the SQL user name and password for the data source.

Add the data source in Report Designer:

1. Open ‘Report designer > Data > Data Sources’.
2. Click ‘Add’.
3. Enter the name of the data source and select the’SQL Service Provider’.
4. Select the new data source and click ‘Configure’.
5. Enter the ‘Connection String’.

If you are viewing this article from the Sage website, a list of Sage 200 Report Designer articles are now .