Re: SQL Server 2000 with Project Server

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 02/18/03


From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 17 Feb 2003 21:13:21 -0700


The accounts required and how they need to be configured
depending on your installation are listed in the Project
Server Resource Kit - watch out for line wrap on the link:
http://www.microsoft.com/technet/prodtechnol/project/project2002/reskit/ps02/psdply/psbscnst.asp
Check the section on Security and User Accounts Required for
Microsoft Project Server.
You can also find information in the Project Server
Installation Guide on the CD - look for the help file
PJSVR10.CHM. In the reference section check the Overview of
Microsoft Project Server security topic.
It's hard to say exactly what steps you may have missed
configuration of Project Server isn't all that simple. Make
sure you are following all the steps in the same order
outlined in the docs.

-Sue

On Mon, 17 Feb 2003 18:46:33 -0800, "David Stewart"
<david.m.stewart@cwfl.com.au> wrote:

>Trying to install Project Server for the first time and
>setup stops with the message 'The specified
>MSProjectServerRole account is not in the
>MSProjectServerRole role'. The user/account that I've
>used is the only user in the role and for SQL Server has
>roles of System Administrator, Secutiry Administrator and
>Database Creator and has access (only) to the project
>database. In the project database the user has
>permissions for public, db_accessadmin, db_securityadmin,
>db_ddladmin, db_datareader, db_datawriter and
>MSProjectServerRole.
>What else do I have to set up to make this work??
>
>Thanks
>David



Relevant Pages

  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • RE: sps Recovery ERROR:database schema is too old to perform
    ... Basically I was trying to use both the content and the configuration ... database files of WSS on a virtual server "MyWSS" that used to ... "MyServer2" with the same virtual server name... ... database server needed to be changed as well. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... the installation hangs at "Validating User. ... > Database 'msdb' cannot be opened. ... > See the SQL Server errorlog for more information. ...
    (microsoft.public.sqlserver.setup)
  • Re: major security concern - any sql user with minimal permission can see code for all stored procs
    ... this you may well enter the realm of an unsupported configuration and that's ... > things - and hence has enterprise manager - then this approach won't work. ... > If you just want to lock down a database, then I'd try my approace - lock ... >>> who needed to execute an SP on my server at his location. ...
    (microsoft.public.sqlserver.security)
  • Re: The Web site that is referenced here is not in the configurati
    ... there's a link to the ISA Server. ... The question is what is happening with the Config Database that leads to the ... disappearance of the top-level web site form the configuration. ... A client of ours has an installation of SBS2003 Premium. ...
    (microsoft.public.sharepoint.windowsservices)