Dynamics GP 10.0 on Microsoft SQL Server 2008 Notes

Nov 16
08:31

2009

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

If you plan to deploy Microsoft Dynamics GP on Windows 2008 and Microsoft SQL Server 2008, most if not all possible questions and problems are resolved automatically. There were known issues when you were deploying Dynamics GP 10.0 on Windows 2008 and Microsoft SQL Server 2005 - to name it - you had to open 1433 SQL Server listening port

mediaimage
However,Dynamics GP 10.0 on Microsoft SQL Server 2008 Notes  Articles it looks like if you are installing Microsoft SQL Server 2008, port opening is happening automatically, so Microsoft is making progress in installation friendliness.  The same should be said about Microsoft Windows 7 Operating System - you can now install Dynamics GP 10.0 from its original CD1 (work around is not required, comparing to Windows XP SP3 and Microsoft Office 2003 or 2007).  Plus, we tested that for Windows 7 you do not have to disable User Account Control as it was required for Vista.  Obviously Windows 7 is just released for deployment in October 2009, but so far most of the feed backs are positive.  Hopefully Windows 7 will lead the parade of the technologies:
1. Testing depth.   We had such customizations and reporting tools in place as eOne Extender Enterprise and Crystal Reports 10.0.  Both of them seem to be compatible with Windows 2008 and SQL Server 2008, we had to figure out how to create ODBC DSN 32 bit on 64 Bit Windows 2008 Server, but this was minor problem.  Crystal Reports were very structured and based on MS SQL Server Views.  In general it is good idea to abstract Crystal Report or any other report: SSRS, Microsoft Access, Excel, etc. from its database query.  Besides Reporting we tried such add-ons, as Dynamics GP Fixed Assets, Project Accounting, Manufacturing, Field Service, FRX.  We tested Dynamics GP over Windows 7 and Windows 2008 Server and MS SQL Server 2008 in November 2009
2. Concerns we heard from Dynamics GP 10.0 users .  Why Dynamics GP starting with version 10.0 opens new Windows application or screen for each new window?  Formerly, for example for Dynamics GP 9.0 all the GP screens were controlled within the one application.  We addressed this question to several Dynamics GP Gurus and we got the answer that it is the way to go and face the future.  For us it is OK, and our accountant can manage multiple windows open at the same time.  However we respect the problem and its potential exposure.  Some of the users computers are relatively restricted in functionality and you have to open your Corporate ERP application to the users with limited decision making options
3. How to get additional help?  We encourage you to search in google for Dynamics GP video demos and presentations.  Our web engineers are deploying web casting technologies, similar to the ones used in Youtube and Google Video to provide free Dynamics GP internet video presentations.  Feel free to call or email our office.  Service is available virtually Worldwide via remote connections, web sessions and phone conferences.  We will be happy to travel to your USA, Canada, Brazil or international based office or facility, if required.  Our consultants speak English, Chinese, Portuguese, Spanish, Russian, Filipino and other languages