Data Base Problem - Commerce server

This is a discussion on Data Base Problem - Commerce server ; Hi, I have an environment like this: Commerce Server 2002 with FP1, CMS 2002 with SP1a, SQL Server 2000. These are all installed on the same machine. I separate the SQL Server to another machine. There is no problem with ...

+ Reply to Thread
Results 1 to 2 of 2

Data Base Problem

  1. Default Data Base Problem

    Hi,

    I have an environment like this: Commerce Server 2002 with
    FP1, CMS 2002 with SP1a, SQL Server 2000. These are all
    installed on the same machine. I separate the SQL Server
    to another machine. There is no problem with CMS, but
    there is an authorization problem with CS. The problem is
    I must give some rights to local ASPNET account in the SQL
    Server, but since all machines are in a domain, the SQL
    Server does not accept a local account for giving rights.
    Do you have any idea about setting the rights of a CS site
    with a remote SQL Server?

    Thanks in advance



  2. Default Re: Data Base Problem

    Abdullah,

    if you have setup your infrastructure in an Active Directory domain,
    you should have a domain level ASPNet account. This the context that
    your webservers should be running in, and you will need to grant
    access to in your SQL database.

    HTH.

    "Abdullah YILDIZ" <abdullah.yildiz@discussions.microsoft.com> wrote in message news:<3c8b01c4c593$729617c0$a401280a@phx.gbl>...
    > Hi,
    >
    > I have an environment like this: Commerce Server 2002 with
    > FP1, CMS 2002 with SP1a, SQL Server 2000. These are all
    > installed on the same machine. I separate the SQL Server
    > to another machine. There is no problem with CMS, but
    > there is an authorization problem with CS. The problem is
    > I must give some rights to local ASPNET account in the SQL
    > Server, but since all machines are in a domain, the SQL
    > Server does not accept a local account for giving rights.
    > Do you have any idea about setting the rights of a CS site
    > with a remote SQL Server?
    >
    > Thanks in advance


+ Reply to Thread

Similar Threads

  1. Replies: 7
    Last Post: 11-20-2007, 05:21 PM
  2. Data Base Testing
    By Application Development in forum Software-Testing
    Replies: 1
    Last Post: 04-16-2007, 03:09 AM
  3. data base testing
    By Application Development in forum Software-Testing
    Replies: 5
    Last Post: 08-10-2006, 01:40 PM
  4. data base opening problem
    By Application Development in forum basic.visual
    Replies: 5
    Last Post: 05-11-2005, 08:05 PM
  5. Vb6 - Ado - Internet Data Base
    By Application Development in forum basic.visual
    Replies: 0
    Last Post: 12-20-2004, 10:42 AM