Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

After reinstalling SQL Server 2005 in MS Dynamics GP, how do I reconnect to the Dynamics application?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

My client is using MS Dynamics GPO 10.0 but is getting SQL Server errors on startup (Windows 2003 Small Business.)   It's SQL Server 2005 and I'm assuming I need to reinstall all the components of SQL Server.  I also gather that I need to completely uninstall first (I tried just installing over the old version and it failed.)  If this is true and I do successfully reinstall, how do I reconnect it to MS Dynamics.  I did all this with an installation of MS Dynamics POS a few years ago, but I don't recall how it all connected.

I need to get it right quickly because the business pretty much revolves around this.  Oh, and Dynamics still works, but they find themselves restarting the server quite a bit and I'm hoping this will fix the problem. 

I'm pasting in the errors we see on startup in case that helps.  Thanks for any help!!

….

Your SQL Server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). uninstall then re-run setup to correct this problem.
Execution cannot continue as the language dependent resource file C:\Program Files\80\Tools\Binn\Resources\1033\SQLSVC.RLL could not be loaded.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: After reinstalling SQL Server 2005 in MS Dynamics GP, how do I reconnect to the Dynamics application?

    Thank you.  These instructions look quite explicit.  I'm guessing the ODBC connection is already existent so I assume I will just have to do the connecting.  I'll look into hardware issues first as suggested in your last post.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: After reinstalling SQL Server 2005 in MS Dynamics GP, how do I reconnect to the Dynamics application?

    Use the 32 bit ODBC Administrator to create the connection.  This article will guide you.

    https://community.dynamics.com/gp/b/azurecurve/archive/2012/09/25/how-to-create-an-odbc-for-microsoft-dynamics-gp-2010

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: After reinstalling SQL Server 2005 in MS Dynamics GP, how do I reconnect to the Dynamics application?

    Thanks, I will check the onboard diagnostics.  However, assuming there's no issue and after installation, how will the MS Dynamics recognize the database if nothing else has changed.  I believe I had to connect through the Dynamics interface when I did this on Dynamics POS.  I had the luxury of having that in my shop for a long weekend and I'm not sure I can manage that this time.  I was hoping someone has done this on this forum.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: After reinstalling SQL Server 2005 in MS Dynamics GP, how do I reconnect to the Dynamics application?

    I would suspect your hardware has issues. Run diagnostics on the hard drives and memory. I would then uninstall SQL and reinstall using a different install media kit. You also want to check other software that is installed and check for conflicts.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans