CS 2007 Starter Site - SampleDataImport catalog failure

I am getting a failure running SampleImportData on the commerce server 2007
starter site. It appears to fail setting up catalog data.

This is what I get:

Loading data into site: StarterSite

Connecting to Catalog system: Done.
Connecting to Orders system: Done.
Connecting to Marketing system: Done.
Adding the user D3JMPL91\Jason Duncan to AzMan policy files:
MarketingAuthorizationStore.xml
MarketingSystem
MarketingAdministrator
OrdersAuthorizationStore.xml
OrderSystem
OrdersAdministrator
ProfilesAuthorizationStore.xml
ProfileSystem
ProfileAdministrator
CatalogAuthorizationStore.xml
CatalogandInventorySystem
Administrator
Creating payment methods:
Visa
Mastercard
Discover
American Express
Creating shipping methods:
Ground (5-7 Days)
Second-Day Air
Next-Day Air
Generating encryption keys: Done.
Adding encryption keys to web.config: Done.
Adding encryption keys to web.config for the ProfilesWebService: Done.
Importing catalog:
* Warning: The following errors occured during import:
* You are not authorized to perform the import operation. Ensure that you
have adequate permissions to perform the import
* operation before running this tool.
Done.
Updating Inventory resource:
Importing inventory catalog:
* Warning: The following errors occured during import:
* You are not authorized to perform the import operation. Ensure that you
have adequate permissions to perform the import
* operation before running this tool.
Done.

* - error lines shown in yellow

The starter site appears to be functioning except it has no products and I
cannot connect via the Catalog Manager. Can anyone please give me some tips
on getting the catalog service working Or even information on how to debug
this problem further would be very helpful. Thank you.

Answer this question

CS 2007 Starter Site - SampleDataImport catalog failure

xlordt
You need to assign the account running the CatalogWebservice to the ctlg_CatalogWriterRole Sql Role

See this link

http://download.microsoft.com/download/3/a/4/3a46267f-9640-4623-86a1-c63bbfea9e1d/Installation%20and%20Configuration%20Guide%20for%20Microsoft%20Commerce%20Server%202007.html
Mr. SOAPitStop
I've added in AuthorizationManager for Catalog, Inventory...the group Users and it worked. It's not good for real world scenario at all, but if you want to just how StarterSite it's working its good
Darren.Sim
Did you follow the steps of the Installation Guide It looks like your SQL Server permissions haven't been set correctly.
Thomas Epting
Hi,

To whom and where did you add authorization I have the exact same problem and have tried to add my user to CatalogAdministrator and a few others with no luck.

Thanks in advance.

/Marc
meconnell
I added authorizations via the Authorization Manager and now I am getting a different failure doing the same starter site SampleDataImport:

Error: EXECUTE permission denied on object 'upld_spCreateChunkUploadRecord', database 'StarterSite_productcatalog', sch
ema 'dbo'.

Any ideas
CS 2007 Starter Site - SampleDataImport catalog failure

Answer this question