RE: [development-axapta] AX SP2 database error..

[Preston A. Larimer]

Anil,   Look on your SQL server at the Master data base views there should be approximately 20 views with the owner listed as INFORMATION_SCHEMA, in particular the one view named VIEWS is what Axapta is trying to use,  If the owner is DBO it would be my guess you at some time accidentally ran a script against the Master DB that changed the owner of all objects to DBO.  If this is your problem here’s a SQL script to fix it,   Have a good back up of the MASTER db and then run this against the MASTER db using query analyzer, it will set all of the views in sql standard that are supposed to belong to Information_Schema ownership.   Best regards -Preston               use Master             go             exec sp_configure 'allow updates', 1              reconfigure WITH OVERRIDE              go                          Begin Transaction              update sysObject              set uid = user_id('INFORMATION_SCHEMA')              where name in(                         SCHEMATA,                         TABLES,                         TABLE_CONSTRAINTS,                         TABLE_PRIVILEGES,                         COLUMNS,                         COLUMN_DOMAIN_USAGE,                         COLUMN_PRIVILEGES,                         DOMAINS,                         DOMAIN_CONSTRAINTS,                         KEY_COLUMN_USAGE,                         REFERENTIAL_CONSTRAINTS,                         CHECK_CONSTRAINTS,                         CONSTRAINT_TABLE_USAGE,                         CONSTRAINT_COLUMN_USAGE,                         VIEWS,                         VIEW_TABLE_USAGE,                         VIEW_COLUMN_USAGE,                         ROUTINES,                         PARAMETERS,             ROUTINE_COLUMNS)                             Commit Transaction                          exec sp_configure 'allow updates', 0              reconfigure WITH OVERRIDE       -----Original Message----- From: Anil Ozay [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] AX SP2 database error..   Thanks for all replies.. I checked user rights on SQL Server, owner of the views is the same owner of the tables. But i can’t find any solution.   I use a clear solution, i reinstall the Axapta. No matters now..   Regards,   Anil Ozay   From: ax [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 9:28 AM To: [EMAIL PROTECTED] Subject: Re: [development-axapta] AX SP2 database error..   The problem may include user rights in MS Sql . Check if sql is configured with windows and sql authorisation... Kuni ----- Original Message ----- From: Anil  <mailto:[EMAIL PROTECTED]> Ozay To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>  Sent: Monday, March 22, 2004 5:46 PM Subject: [development-axapta] AX SP2 database error.. Hi all.. We have installed Axapta SP2 after new installation. After that, we import sample data from Axapta installation CD. We have trouble about simple data. When we synchronize database, errors occured. You can view that from attached picture.. Do you have any idea?? Thanks, Anil   _____  Yahoo! Groups Links *      To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <http://groups.yahoo.com/group/development-axapta/>   *      To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>   *      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .   Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.