September 2015

    1.  In SQL Management Studio, run this script to remove the existing password. UPDATE DYNAMICS.SY02400 SET PASSWORD = 0x0202020202020202020202020202020 2.  In GP, reset the system password.

  Latest Service Pack At this writing it is very important when upgrading to Dynamics GP 2015 that you are on the current service pack/hotfix release. There are known issues that were resolved. Prior Version data in Tables Use the reference below to untangle the problems of prior versions in the tables https://community.dynamics.com/gp/f/32/t/134557

  select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

    select name, compatibility_level , version_name = CASE compatibility_level    WHEN 65  THEN ‘SQL Server 6.5’    WHEN 70  THEN ‘SQL Server 7.0’    WHEN 80  THEN ‘SQL Server 2000’    WHEN 90  THEN ‘SQL Server 2005’    WHEN 100 THEN ‘SQL Server 2008/R2’    WHEN 110 THEN ‘SQL Server 2012’    WHEN 120 THEN ‘SQL Server 2014’ENDfrom sys.databases

  To enable CLR on SQL Server run this script:   sp_configure ‘clr enabled’, 1GORECONFIGUREGO

    SELECT  INTERID ‘Database’, CMPNYNAM ‘Company_Name’ FROM DYNAMICS..SY01500

  If you find that you click any item in MAX and you get no response as in adding a part or if you try to update a part and receive an DB Error 4. This could be cause by SQL Server CLR not being enabled. Check your SQL Server or ask your DB admin…

/* Code to List all Recovery Models */ select [name], DATABASEPROPERTYEX([name],’recovery’)from sysdatabaseswhere name not in (‘master’,’model’,’tempdb’,’msdb’)

1) Make sure that you have your anti-virus turned off. 2) Check your User Account control settings and make sure they are off 3) Make sure that .Net 3.51 is installed. 4) A new fresh install can also solve any issue that might be present due to other apps installed after MAX has been installed….

    http://sqlserverbuilds.blogspot.com/