Error "Schema needs to be updated. Contact your system administrator." When Creating a New Application Catalog.
SummaryError "Schema needs to be updated. Contact your system administrator." When Creating a New Application Catalog.
SynopsisUnder certain circumstances when you try to create a new Application Catalog through the Application Catalog Wizard you may receive the error "Schema needs to be updated. Contact your system administrator."
This error is commonly caused by one of the following factors:
1: You have installed AdminStudio to either Windows 7 or Server 2008 R2 without Service Pack 1 applied.
2: You or your DBA have created a blank database, and you are trying to specify this blank database in the Application Catalog Wizard.
3: The account you are using to create the database does not have the proper rights in SQL to create the database.
Below are the recommended steps to resolve this error:
1: Simply apply Service Pack 1 for Windows 7 or Server 2008 R2 and the error should be resolved.
2: If you are using the Application Catalog Wizard do not specify a blank database as the Application Catalog Wizard will handle the creation of the database. If you are required to use a blank database provided to you then you will need to manually create the Application Catalog by running the provided SQL scripts:
3: The account being used to create the Application Catalog will require at least DBO rights. Another alternative would be having your DBA login with their SA account just for the creation of the Application Catalog.
Additional InformationFor more information on the creation of the Application Catalog please refer to the following Helpnet article Creating New Application Catalogs Using the AdminStudio Interface