Re: Problems with WSS 2.0 and Remote SQL

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

From: Chuck Ladd (cladd01_at_Remove.hotmail.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 11:56:09 -0500

I did use the domain name when specifing the admin account, I also granted
the (Domain Name)\(Machine Name)$ account security admin and database
creator rights on the SQL Server, it appears that the databases are being
created with out any issue.

"Shawn" <shawn@issda.com> wrote in message
news:uVZxLki%23DHA.2808@TK2MSFTNGP10.phx.gbl...
> You must specify the domain name as well (e.g. myDomain\Myuser). Plus
WSS
> must have access to the SQL box...you can verify this in the Adminstrator
> pages.
>
> Shawn
>
>
> "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: sbs2003 to (new)server2003 user issue
    ... You have not just add the "name" to ADUC, rightclick My Computer icon on the desktop, choose properties, go to network identification tab, here click properties and choose under Member of "Domain", fill in the domain name and a window will open asking you for an account from the domain with the password. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Laptop not/never part of the domain. ... sbs server dead sunday night. ...
    (microsoft.public.windows.server.active_directory)
  • Re: sbs2003 to (new)server2003 user issue
    ... Meinolf Weber ... This posting is provided "AS IS" with no warranties, and confers no rights. ... sbs server dead sunday night. ... Even if the account in the domain and the local account on the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Windows 2003 Users vs Software
    ... You need to have both an admin and a limited account ... >> as a limited user, to effect, "the software has not been installed ... The users do not have rights to install programs. ...
    (microsoft.public.security)
  • Re: New to SMS - have a Collections question.
    ... local admin of both the SMS server and the server the database is on. ... However this is a security problem. ... Access to objects is based on Security Rights (if you scroll down the ...
    (microsoft.public.sms.admin)
  • Re: Restored Server but SharePoint refusing admin access
    ... > SID/BID or remove the user from the database and add it again. ... >, In SQL Configuration Manager go to SQL> Server ... > you had) you cannot access the database from that account. ... > newly added administrator account (for me, since I added a new admin ...
    (microsoft.public.windows.server.sbs)