Re: Rights Issue

From: Karsten Grombach (karsten.nogrombach_at_spam.tria.de)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 19:09:18 +0200

Ok. Finaly tracked it down.
The user has to be dbo in the config database. nothing else works. reader
and writer seem to suffice in the other databases

thanks for hint jim!

"Jim Duncan" <sorry@no.email> wrote in message
news:uFXchm$WEHA.2176@TK2MSFTNGP11.phx.gbl...
> Hi Karsten,
>
> Just checking... you said 'has read rights on the sql server'. Did you
> really mean only READ rights? The account under which WSS is running needs
> to have more than just READ rights. Installing web parts makes changes to
> the database (as does almost anything else in WSS, even placing a web part
> on a page).
>
>
> "Karsten Grombach" <karsten.nogrombach@spam.tria.de> wrote in message
> news:OstPBNpWEHA.1144@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > i'm trying to configure a sharepoint admin account. When i run it as a
> > domain account, everything works find. When the user is local admin on
all
> > sps servers and has read rights on the sql server, stsadm does not work
> > correctly. ie. i cannot install webparts (critical error: the webpart
> cannot
> > be found in the configuration database) or -o enumsites crashes (the
> command
> > cannot be completed)..
> >
> > we are running sps in the following infrastructure:
> > - 2 Frontend Webservers
> > - 1 Server for Indexing and Jobs
> > - 1 SQL Cluster
> >
> > Running the sharepoint account as domain account is not an option as
> > external people need to uses this account..
> >
> > Any suggestions?
> >
> > Thanks and regards
> > Karsten Grombach
> >
> >
>
>

Relevant Pages

  • Re: Unable to write to user profile...
    ... I've given the account rights to manage profile as well. ... On the database level, could you provide more information on the rights i need to grant the account? ... Microsoft Online Community Support ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot rebuild non-portal-content index
    ... > I added the content index account to the SQL database giving it rights ... create a log-in entry for the new SharePoint account for the SQL ... This is an entirely different task from giving the rights to ... read and write in a particular database. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Best way to parse file into db-type layout?
    ... That's an awful lot of columns to put into a database table, ... The rows are identified by Letter type and an account number (always the ... Off to search for dictionaries and databases now. ... > What you need is a clear appreciation of what you are trying to do ...
    (comp.lang.python)
  • Re: Help with WSS 3.0 Server Farm Config - Backend SQL 2005
    ... I had to use only "sharepoint" to get the ... What interest me though is that the database get created but fails after ... Virtual Server with DBSVR ... an account local to the WEBSVR) to create and access the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)