Amit's Technical World

Error while importing Catalog

While importing catalog in commerce server, if you are facing access denied error, please check following 1. Have sufficient permission in SQL Server for the Application pool identity (under which the Catalog Web Service is running) Following DB permissions

Access required in SQL server while creating a new site in Commerce Server 2007 : For a single user

After creating a site in Commerce Server 2007, following roles need to be mapped to the user (under which context the commerce server web srevices are running). Database Name Role MSCS_Admin db_datareader admin_reader_role MSCS_CatalogScratch db_datareader