Welcome to MSDN Blogs Sign in | Join | Help
Wednesday, March 28, 2007 12:16 AM

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 are required for the Application Pool Identity (under which the Catalog Web Service is running)

 

Database Name

Roles

MSCS_Admin

admin_reader_role

 

MSCS_CatalogScratch

db_datareader, db_datawriter, db_ddladmin

<SiteName>_ProductCatalog

ctlg_CatalogWriterRole, db_datareader, db_datawriter, db_ddladmin, db_securityadmin, Inventory_ReaderRole, Inventory_WriterRole

2. The Application Pool Identity (under which the Catalog Web Service is running) user has Read, Execute and Write permission on the CatalogAuthorizationStore.xml

3. The Application Pool Identity (under which the Catalog Web Service is running) user access on Windows Temp directory

4. The Application Pool Identity (under which the Catalog Web Service is running) user access on ASP.net temporary files directory

Posted by AmitAgrawal | 1 Comments
Wednesday, March 28, 2007 12:11 AM

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

 

db_datawriter

 

db_ddladmin

<SiteName>_productcatalog

ctlg_CatalogWriterRole

 

db_datareader

 

db_datawriter

 

db_ddladmin

 

db_securityadmin

 

Inventory_ReaderRole

 

Inventory_WriterRole

 

ctlg_CatalogReaderRole

 

Inventory_RuntimeRole

<SiteName>_marketing

mktg_MarketingService_role

 

mktg_promoCodeGenerator_role

 

db_ddladmin

 

mktg_runtime_role

 

mktg_directmailer_role

 

mktg_staging_role

<SiteName>_marketing_lists

db_owner

 

db_datareader

<SiteName>_profiles

Profile_Schema_Manager

 

Profile_Runtime

<SiteName>_transactionconfig

Orders_Management

 

Orders_Runtime

<SiteName>_transactions

Orders_Management

 

Orders_Runtime

Posted by AmitAgrawal | 1 Comments
Friday, November 17, 2006 4:29 AM

Authenticating an account in AD which is created using CS 2007 Profile APIs

CS 2007 supports storing profile information in a combination of data source i.e. while creating a profile it is possible to store some information in a database (say SQL 2005) and some other information in Active Directory. In our application we were storing the user name, password, first name, last name etc in AD and other information was being stored in SQL 2005 database. While authenticating the user by providing UserId and password, AD validates the UserId against userPrincipalName. Unless this field is set to same a UserId, AD will not be able to authenticate the user. Hence while creating the account in AD using CS 2007 APIs, we need to set userPrincipalName as UserId. So while storing the User information in AD, these are the minimum set of information you may wish to map.

1. Cn = Common Name, same as UserId

2. sAmAccountName = Account Name, same as UserId

3. Givenname = First name

4. Sn -> LastName

5. userAccountControl as 101 to set the user as active

6. userPrincipalName as UserId to authenticate using AD

Posted by AmitAgrawal | 1 Comments
Sunday, November 12, 2006 5:57 AM

How to activate an account in AD which is created using CS 2007 Profile APIs

CS 2007 supports storing profile information in a combination of data source i.e. while creating a profile it is possible to store some information in a database (say SQL 2005) and some other information in Active Directory. In our application we were storing the user name, password, first name, last name etc in AD and other information was being stored in SQL 2005 database.

While creating the profile using profile APIs (Profile APIs, Profile webservice or Profile Adapter for BizTalk), we observed that the account is successfully created in AD however the same is not yet activated/enabled. In order to enable the account in AD, we need to use the userAccountControl property in AD and set the same to 101. 101 is the AD code for active account. This is the attribute we need to set for the account in AD to make it active. 

 

Posted by AmitAgrawal | 1 Comments
Monday, November 06, 2006 3:39 AM

Namespace Issue while configuring BizTalk adapter for CS 2007

While importing a profile using CS Adapters for BizTalk Server, we run into some problem. We were trying to import an address profile to and were getting an error saying "GeneralInfo.address_id" element is not found in the message schema.

We generated the schema for CS Profiles using ExportProfile.xsd tool. This tool exposes various command line options and one of the options is tn. If this argument is provided, the XSD will be
generated with the target namespace specified.  If not provided, an empty
namespace will be used. 

We need to use the same namespace while configuring the CS Adapters for BizTalk.

Another point we need to ensure is to make these schema as unqualified while using. This will solve the issue.

Thanks

Posted by AmitAgrawal | 1 Comments
Sunday, November 05, 2006 11:32 AM

Biztalk Adapters for CS 2007

One new feature in CS 2007 is the inclusion of Adapters for BizTalk 2006 which can help to integrate with diverse systems like CRM. Inventory etc.

 There are 4 adapters provided by default

1. Commerce Server Profiles Adapter

2. Commerce Server Orders Adapter

3. Commerce Server Catalog Adapter

4. Commerce Server Inventory Adapter

Even though we can access the WebSrevices exposed by CS 2007 using SOAP messages over HTTP, these adapters makes it easy to integrate CS 2007 with other applications like CRM etc.

In my subsequent posts, I will provide some important aspects on these adapters.

 

Thanks

Amit

 

Posted by AmitAgrawal | 1 Comments
 
Page view tracker