March 20, 2012 at 12:43 am
[font="Verdana"]
When I tried to insert the new field into the Microsoft Ax dynamics 2009 custtable(table name) it is not synchronizing while that particular table is configured for the transactional replication (USING SQL SERVER 2008R2)----- throwing the error as---> cannot execute the data definition language command on (). The sql database has issued an error.
And problems during the sql data dictionary synchronization.
In the event viewer the error description is as bellow.....
Object Server 02: The database reported (session 3 (Admin)): [Microsoft][SQL Native Client][SQL Server]Only members of the sysadmin fixed server role or
Db_owner fixed database role can perform this operation. Contact an administrator with sufficient
Permissions to perform this operation... The SQL statement was: "ALTER TABLE CUSTTABLE ADD FIELD1 NVARCHAR (10) NOT NULL DEFAULT ‘‘“
But the user, whose is logged in AX and trying to add a new field is having the full rights to SQL Server.
He is having sysadmin & db_owner rights.
What could be the problem? How to resolve it?[/font]
March 20, 2012 at 11:07 am
vrayanapati (3/20/2012)
.....[font="Verdana"]
Only members of the sysadmin fixed server role or
Db_owner fixed database role can perform this operation. Contact an administrator with sufficient
Permissions to perform this operation... [/font]
....
Does this answer your question? The security context you are using to connect to the database with does not have sufficient priviledges
March 21, 2012 at 1:54 am
your confusing the physical user with the actual user, its the user which is running the AOT which needs to be sysadmin or DB_Owner not the user sat in the chair
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply