Re: Problems with WSS 2.0 and Remote SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Iyaz (iyaz_at_invalid.msn.com)
Date: 02/23/04


Date: Mon, 23 Feb 2004 13:24:37 -0800

Do you have correct permissions on the %temp% directory for Network
Service(or STS_WPG) and also on the Temporary ASP.NET files folder under
Microsoft.NET directory. I think IIS_WPG should have permissions to this
(Network Service should have got added to IIS_WPG and STS_WPG, check this
out too). Finally check the Admin guide under the topic Files and
Permissions and it gives the list of permissions required for WSS to work
properly.
-Iyaz
"Adam Macaulay" <macaulay_adam@hotmail.com> wrote in message
news:Oy8dSxk#DHA.2824@tk2msftngp13.phx.gbl...
> Several Items to lead on: Check IIS make sure your authentication rights
are
> correct. Make sure that the account group for SharePoint is set to the
> account group/account you are trying to log in with. If databases are
being
> created I wouldn't worry much about SQL or your App pool as you wouldn't
> have created a configuration database otherwise. If the site gets extended
> it is being so with a user. You may has a side door want to try stsadm -o
> createuser for your site and add another use. This may help.
>
> Hope this helps.
> "Chuck Ladd" <cladd01@Remove.hotmail.com> wrote in message
> news:%23pwrpfi%23DHA.3900@tk2msftngp13.phx.gbl...
> > OK, Im trying to configure WSS 2.0 to use SQL Server 2000 SP3 on the
same
> > machine and I am running into a very weird issue. The server is a
Windows
> > Server 2003 member server of a Windows 2003 AD, I have a seperate
machine
> to
> > act as a DC. I go through the setup for WSS 2.0 using the /remotesql
> switch
> > and everrything appears to go just fine, I check to see that the
databases
> > are created and all looks good. For the Virtual Server Admin account I
use
> > my AD account which has Enterprise Admin and Domain admin rights. I also
> > have local administrative rights to the server which has SQL Server and
> WSS
> > installed.
> >
> > So when the install is complete and I extend the Default Virtual server,
I
> > go to http://localhost and it gives me a template selection page. When I

> > choose a template and hit ok, it pauses for a few seconds then prompts
me
> > for a login, no matter what account I try to log in with it denies me
> > access.
> >
> > Any suggestions or has anyone else had issue's like this? If I so the
> > standard install using MSDE everything works great. My issue is only
when
> > trying to istall with a remote SQL Server.
> >
> > Please Help,
> >
> > Thank you,
> >
> > Chuck Ladd
> >
> >
>
>



Relevant Pages

  • Re: Virtual Directory - Permission Denied with fso CopyFile
    ... TestUser (normal user account with same credentials on all machines). ... I created a share on a remote server. ... reviewing it's sharing permissions and security tab permissions "everyone" ... "directory security" tab on the vdir and selecting, edit, edit and manually ...
    (microsoft.public.inetserver.iis)
  • Re: Incoming E-Mail - cant create contact in OU
    ... account out of local administrator to attempt to find any denied access. ... I then added full permissions to my user account on both of these keys, ... local admin rights to the server hosting incoming email. ... what permission I need to give the app pool locally to avoid this issue. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Incoming E-Mail - cant create contact in OU
    ... account out of local administrator to attempt to find any denied ... I then added full permissions to my user account on both of these keys, ... that's for every app pool you create for every new web app on the ... local admin rights to the server hosting incoming email. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: NTFS owner problem
    ... power options, ... permissions that control access. ... to which any admin account should have full access. ...
    (microsoft.public.windowsxp.security_admin)
  • RE: SBS 2003/member Web Server and ISUR access
    ... NTFS permissions for the directories and files ... the IIS content directories have the following permissions. ... Server Extensions, ASPNET, SQL Server and other software is installed. ... The IUSR_MachineName account has the following permissions. ...
    (microsoft.public.windows.server.sbs)