Tool Kit User for AX 2012 R3 for Retail

Setting up a Tool Kit User for AX 2012 R3 for Retail can be a bit trying, espcially since the techNet article for this topic is based on 2012 FP and is no longer current. If you are getting this error, you may need to setup direct SQL db level access.

Method 'ViewPage' in COM object of class '_ButtonGrid' returned error code 0x80131904 (<unknown>) which means: Login failed for user 'MyDomain\My.User'.

Below is a shortcut for all the SQL permissions that need to be configured for each user that will be doing anything with the receipt or form layout designers. Replace MyDomain\MyUser with the appropriate values like AtomicAX\Nathan.Clouse

IF NOT EXISTS 
    (SELECT name  
     FROM master.sys.server_principals
     WHERE name = 'MyDomain\MyUser')
BEGIN
    CREATE LOGIN [MyDomain\MyUser] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
END


GRANT SELECT ON [dbo].[INVENTTABLE] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[INVENTITEMBARCODE] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILOPERATIONS] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILSALESTAXOVERRIDE] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILSALESTAXOVERRIDEGROUPMEMBER] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILSTORETENDERTYPETABLE] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILTERMINALCUSTOMFIELD] TO [MyDomain\MyUser]
GRANT DELETE ON [dbo].[RETAILBUTTONGRID] TO [MyDomain\MyUser]
GRANT INSERT ON [dbo].[RETAILBUTTONGRID] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILBUTTONGRID] TO [MyDomain\MyUser]
GRANT UPDATE ON [dbo].[RETAILBUTTONGRID] TO [MyDomain\MyUser]
GRANT DELETE ON [dbo].[RETAILBUTTONGRIDBUTTONS] TO [MyDomain\MyUser]
GRANT INSERT ON [dbo].[RETAILBUTTONGRIDBUTTONS] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILBUTTONGRIDBUTTONS] TO [MyDomain\MyUser]
GRANT UPDATE ON [dbo].[RETAILBUTTONGRIDBUTTONS] TO [MyDomain\MyUser]
GRANT DELETE ON [dbo].[RETAILFORMLAYOUT] TO [MyDomain\MyUser]
GRANT INSERT ON [dbo].[RETAILFORMLAYOUT] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILFORMLAYOUT] TO [MyDomain\MyUser]
GRANT UPDATE ON [dbo].[RETAILFORMLAYOUT] TO [MyDomain\MyUser]
GRANT DELETE ON [dbo].[RETAILIMAGES] TO [MyDomain\MyUser]
GRANT INSERT ON [dbo].[RETAILIMAGES] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILIMAGES] TO [MyDomain\MyUser]
GRANT UPDATE ON [dbo].[RETAILIMAGES] TO [MyDomain\MyUser]
GRANT DELETE ON [dbo].[RETAILTILLLAYOUT] TO [MyDomain\MyUser]
GRANT INSERT ON [dbo].[RETAILTILLLAYOUT] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILTILLLAYOUT] TO [MyDomain\MyUser]
GRANT UPDATE ON [dbo].[RETAILTILLLAYOUT] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILTILLLAYOUTZONEREFERENCE] TO [MyDomain\MyUser]
GRANT SELECT ON [dbo].[RETAILTILLLAYOUTZONE] TO [MyDomain\MyUser]