SPS 2003 and SQL 2000 configuration

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Edouard LECOQ (elecoq_at_saur.fr)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 09:10:02 -0800

Whe have 2 domains (appoved 2 way) on the same forest,
one domain (d1) hosting this SPS server, the second (d2)
hosting SQL Server (multiple instances).

The account running SPS and having access to the database
is on the d1 domain.

Can anyone tell me which are the minimum rights to grant
to this account on the specific instance of the SQL
server ?

Relevant Pages

  • Re: CreateObject, GetObject and COM instances - need help!
    ... COM servers can be classified as Multiuse or Single Use ... COM server, the server uses only one instance of the .exe file to create ... In the Single Use (Multiple Instances) ... The fact that you can launch multiple processes of your App ...
    (microsoft.public.vsnet.general)
  • Re: Running multiple instances in production environment. Good or bad?
    ... are severe memory limitations on the 32-bit platform. ... SQL Server Standard Edition can use up to 2 GB for the Buffer Pool. ... I have read some of the postings in this forum, and most of them seem to be negative to running multiple instances in a production environment, mainly due to the fact they will compete for system resources. ...
    (microsoft.public.sqlserver.server)
  • Re: Active/Passive to Active/Active
    ... If your application cannot run in multiple instances then you are limited to ... so build yourself a cluster using Microsoft Virtual Server or ... VMWare Server, and you can practice away without doing "harm" to your ...
    (microsoft.public.windows.server.clustering)
  • Re: Process instanses for COM local server implementation
    ... always work in current logged-in user context and should not have ... multiple instances. ... If the server is still running, and the user account of the client is ...
    (microsoft.public.vc.atl)
  • Re: AS2005: Multiple developpers with Source Safe and 1 OLAP Server...
    ... By having multiple instances you can provide each developer with an isolated ... * cost to upgrade each dev. ... server(s) side; also my server use more memory, ... but giving 1 instance by developper... ...
    (microsoft.public.sqlserver.olap)