Dynamic AI - Microsoft SQL Server

Support documents related to Microsoft SQL Server, Microsoft SQL Server Express, Microsoft Access and Microsoft Excel Databases

Dynamic AI - Microsoft SQL Server

Postby admin » Fri Jan 16, 2009 4:36 pm

Connecting Dynamic AI to Microsoft SQL Server

Dynamic AI supports all versions of Microsoft SQL Server since version 7.

Necessary drivers are almost always present on windows computers. To make sure you have the latest version of the drivers, you can download and install the latest Microsoft Data Access Components package from Microsofts web site.

To connect to a Microsoft SQL database, use the database tab (bottom of the screen) and select NEW | Database connection. Pick Microsoft SQL Database from the Type list. Now follow the next steps.

Specify the location of the SQL server (as host name or IP address) in the Server field.


In cases where the default port has been changed on the SQL Server, specify the port by adding ",9615" after the server name. Example: "XPDB, 9615"

Multiple instances of SQL server can run one one server - to access a specific instance, enter the server name followed by a backslash and the instance name. Example: "XPDB\Instance2"

The Owner/Catalog field is optional.


Dynamic AI uses Microsoft SQL Server Authentication for connecting to the SQL server - enter username and password of an account with permissions to read the necessary tables.

The system account is typically called SA - if you cannot connect with the chosen account, it sometimes helps to try using SA. If SA works, then the fault lies with the permissions of the other account.

The SQL Server must accept SQL-Server Authentication.

Test the connection by pressing the ‘Test Connection’ button.

Click SAVE to save the connection. Now you should see the database in the database Explore and be able to browse and use Tables and Views of the database.

If no Owner/Catalog is specified all underlying schema's that the user has access to will be available from Explore database connection:


If Owner/Catalog is specified - only that particular schema will be accessible:


Interested in a free Dynamic AI Personal edition? Download the latest version from: http://www.dynamicai.com/download.htm

Would you like a Dynamic AI Server edition trial version please contact: info@dataaccess.nl

If you have any questions, you are always welcome to contact one of our partners (more information available at: www.dynamicai.eu , www.dynamicai.com) in your country, or e-mail your questions directly to: info@dataaccess.nl

Copyright © 1998-2009 CINTAC A/S and/or its suppliers. All rights reserved. Dynamic AI ™, Dynamic Financials ® and CINTAC Dynamic are registered trademarks or trademarks of CINTAC A/S.
Microsoft, Windows and SQL Server are registered trademarks of Microsoft Corporation. All other products may be trademarks or registered trademarks of their respective companies.
User avatar
Certified Dynamic AI Professional
Posts: 177
Joined: Thu Jan 01, 1970 1:00 am
Location: Copenhagen, Denmark

Return to Microsoft SQL Server / Express / Access / Excel