NAV2018 : Resolving Data source name not found and no default driver specified

While working with Microsoft Dynamics NAV development environment, I encountered this error when trying to select the database.

Error: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified. State ID: IM002

Error IM002

It took me awhile to figure out a way to fix it. To fix this make sure the SQL Server Native Client is installed.

Locate the installation folder and navigate to the “Prerequisite Components” folder within them. This folder contains essential components required for Dynamics NAV. Run the SQL Server Express installer to install the missing component.

Once the installation is complete, you should have the SQL Server Native Client installed on your computer. You can now open the database without encountering the “Data source name not found and no default driver specified” error.

thatnavguy

Experienced NZ-based NAV Developer and Consultant with 15+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central. Passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *