SQL Server 2014 build versions

SQL Server 2014 build versions

This article lists the Microsoft SQL Server 2014 builds that were released after SQL Server 2014 was released.

SQL Server 2014 Service Pack 1 (SP1) and cumulative update (CU) builds

Cumulative update name	Build version	Knowledge Base number
SQL Server 2014 SP1 CU6	12.0.4449.0 (latest build)	KB3144524
SQL Server 2014 SP1 CU5	12.0.4439.1	KB3130926
SQL Server 2014 SP1 CU4	12.0.4436.0	KB3106660
SQL Server 2014 SP1 CU3	12.0.4427.24	KB3094221
SQL Server 2014 SP1 CU2	12.0.4422.0	KB3075950
SQL Server 2014 SP1 CU1	12.0.4416.1	KB3067839
SQL Server 2014 SP1	12.0.4100.1	KB3058865

SQL Server 2014 cumulative update (CU) builds

Cumulative update name	Build version	Knowledge Base number
CU13	12.0.2568.0 (latest build)	KB3144517
CU12	12.0.2564.0	KB3130923
CU11	12.0.2560.0	KB3106659
CU10	12.0.2556.4	KB3094220
CU9	12.0.2553.0	KB3075949
CU8	12.0.2546.0	KB3067836
CU7	12.0.2495.0	KB3046038
CU6	12.0.2480.0	KB3031047
CU5	12.0.2456.0	KB3011055
CU4	12.0.2430.0	KB2999197
CU3	12.0.2402.0	KB2984923
CU2	12.0.2370.0	KB2967546
CU1	12.0.2342.0	KB2931693

Ref : https://support.microsoft.com/en-us/kb/2936603

Ax error " A user session on the server could not be created. Try to start the client again. If the problem continues contact Ax Administrator

Cause:
AOS has no access to createusersessions stored procedure in the database.
Even there will not be any log in Event Viewer for this issue.

Occurrence :
Whenever C:drive of AOS server gets full then this will occur.

Resolution:
Clear the C: drive at-least to 2 GB to run the application.
Best way is to shirk the SQL databases.

Regards,

The user or group name 'DmainName\UserId' is not recognized in AX 2012 R3

Hi,

When  you restore the AOS database from 1 environment to another where there is no relation of domain or user then you will encounter above mentioned error nduring report server validation / creation of folder / making default.

Reason: Existence of records of parent server in the table SysServerSessions.  though you added the new server details as record in SQL level, you needs to delete those records too.

Hope this will solve your error.

Thanks,

The internal time zone version number stored in the database is higher than the version supported by the kernel (8/7). Use a newer Microsoft Dynamics AX kernel

Hi,

This is the error which arrives when you start the service after restoring the database from DB to this concern DB.
This is due to mismatch of the time zone in the AX system.

This error can be noticed only in the event log.

Resolution:
 Open SQL 'SQLSystemVariables' table and edit the record in 'SYSTIMEZONEVERSION' column from 8 to 7.

Regards,