[AX]AX2012导入Demo数据

时间:2022-12-07 12:44:19

从Microsoft customer source(https://mbs.microsoft.com/customersource/downloads/servicepacks/microsoftdynamicsax2012rtm.htm?printpage=false)下载了Demo data(Demo Data for Microsoft Dynamics AX 2012 SYS layer),解压缩后发现这是一个SQL数据库的备份文件。按照说明在“License configuration”中去掉了“Keep update objects 4.0”、“Keep update objects 5.0”、“Keep update objects 6.0”,然后停掉AOS服务,在SQL Management 中恢复/覆盖原来的AX数据库,重新启动AOS的时候错误出来了,检查日志:

Object Server 01:  The database reported (session 1 (-AOS-)): [Microsoft][SQL Server Native Client 10.0][SQL Server]The EXECUTE permission was denied on the 
object 'XU_GetSchemaVersion', database 'MicrosoftDynamicsAX', schema 'dbo'.. The SQL statement was: "{ ? = CALL [dbo].[XU_GetSchemaVersion](?, ?) }"

更具体的:

Object Server 01 : An error situation occurred during synchronization of label files in the model store and the local label files.
 The error reported is: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'XU_GetSchemaVersion', database 'MicrosoftDynamicsAX', schema 'dbo'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
......

大概是新导入的数据库权限的问题,搜索一下看看有没有人和我一样的问题,为数不多的结果里面发现一个法国哥们和我一样:http://mathdax.blogspot.com/2011/04/dynamics-ax-2012-execute-permission-was.html

按照他的办法授予AOS服务用户execute权限:

USE [AX2012CONTOSO]
GO
GRANT EXECUTE TO [domain\aosservice]
GO

再次启动AOS成功了,正常登录没有问题了,只是“Development workspace”灰化打不开,这个Demo的license不能做开发吗?看看license info里面居然到2006/12/1过期,这...