SQL Role Clarification for Marketing Resource

Hot Topic

The MOM2005 Installation
How do I get the notification when the active tab is changed?
WDS 3.0 beta2 Included Locations dissappear
A simple general purpose database using Visual Studio
web testing with IE
WDS crash under Citrix
How to catch the change of toolbar icons size? How to track the state of IE window?
Is it possible to change url in DISPID_BEFORENAVIGATE2 handler?
i need both ie6 and ie7
WDS 3.0 creates "negative Index" :-(

IE Development

IE 7 opening to Run Once page with error on it.
Please give my site a test!!
Help with a Context Menu extension...
Windows Vista Gaming Performance
I.E. 7
Outlook 2003 stuck, probably because of WDS - please help
UPDATING individual products through the Commercer Server adapters
New MSDN BHO Article - Building Browser Helper Objects with Visual Studio 2005
IE7 and desktop icons
Google story and C++ naming ..

SQL Role Clarification for Marketing Resource

It appears there are some differences between the roles assigned for SQL Server 2005 deployments of Commerce Server when you look at the product documentation and the Starter Site. I was hoping to get some clarification from the product group as to why this is

In particular the issues are with the Marketing database:

  • Marketing Web Service Identity
    • CS2007 Docs - mktg_MarketingService_role, mktg_promoCodeGenerator_role, mktg_runtime_role, mktg_dataManager_role
    • Starter Site Install Guide - mktg_MarketingService_role, mktg_promoCodeGenerator_role
  • Orders Web Service Identity
    • CS2007 Docs - mktg_runtime_role
    • Starter Site Install Guide - db_ddladmin, mktg_runtime_role
  • Run Time User Identity
    • CS2007 Docs - mktg_runtime_role
    • Starter Site Install Guide - db_ddladmin, mktg_runtime_role

Any direction on which way to go would be appreciated!

Cheers,
Colin




Answer this question

SQL Role Clarification for Marketing Resource

  • RBowden

    Hey David,

    I'll remove the mktg_runtime_role and mktg_dataManager_role roles from my deployment process.  In a future release it would be great to see a standard naming convention for roles (and everything else) across all of the databases as well.  Auditing all the role configurations prior to deployment is a bit of an eye crosser. :)

    The last two role differences were noted based on the documentation (both RTM and the latest RTW):

    • Starter Site Installation Guide - http://go.microsoft.com/fwlink/ LinkID=71818#Grant_Access_Step2
      • ssOrdersWebSvc -> StarterSite_Marketing -> SQL 2005: mktg_runtime_role, db_ddladmin
      • ssRunTimeUser -> StarterSite_Marketing -> SQL 2005: mktg_runtime_role, db_ddladmi
    • Commerce Server 2007 Installation Guide - http://go.microsoft.com/fwlink/ LinkID=57268#Grant_Access_Step2
      • OrdersWebSvc -> CSharpSite_Marketing -> SQL 2005: mktg_runtime_role, db_ddladmin
      • RunTimeUser -> CSharpSite_Marketing -> SQL 2005: mktg_runtime_role, db_ddladmin
    • How to Associate Database Accounts with Database Roles - ms-help://MS.CS07/cs07default/html/366dbedd-225d-4f4b-a2e2-828989507f31.htm
      • OrdersWebSvc -> CSharpSite_Marketing -> SQL 2005: mktg_runtime_role
      • RunTimeUser -> CSharpSite_Marketing -> SQL 2005: mktg_runtime_role
    • What are the Required Database Accounts and Database Role Mappings - http://msdn2.microsoft.com/en-us/library/aa545240.aspx#Web_Mappings
      • OrdersWebSvc -> <site_name>_Marketing -> SQL 2005: mktg_runtime_role
      • RunTimeUser -> <site_name>_Marketing -> SQL 2005: mktg_runtime_role

    Cheers,
    Colin



  • MShetty

    Hi Colin,

    The CS2007 Starter Site Install guide was updated to remove the two unnecessary roles from the Marketing Web service identity. You definitely win the attention to detail award for picking up on that. We’ll be updating the main product install guide as part of the next documentation refresh. We can’t, however, spot a difference in the other two roles that you have called out. Here are the links we used:

    CS2007: http://go.microsoft.com/fwlink/ LinkID=57268

    Starter Site: http://go.microsoft.com/fwlink/ LinkID=71818

    Thanks for the great question (as usual)!

    -David



  • SQL Role Clarification for Marketing Resource
Answer this question