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.

[2092 byte] By [jtd514] at [2008-1-7]
# 1
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?

jtd514 at 2007-10-2 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 2
Did you follow the steps of the Installation Guide? It looks like your SQL Server permissions haven't been set correctly.
JoeWasson-MSFT at 2007-10-2 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 3

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

VinayakTadas-MSFT at 2007-10-2 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 4

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

Marc.H at 2007-10-2 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 5
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 goodSmile
dragos.pruna at 2007-10-2 > top of Msdn Tech,Commerce Server,Commerce Server 2007...