| Author |
Message |
Glenn Nelson
Guest
|
 Posted:
Wed Nov 09, 2005 9:51 am Post subject:
FAILURE installing WSS with Active Directory auth |
|
|
I asked a question about setconfigdb (on Nov. 7), got no replies. I'm REALLY
stuck. I'm trying to use stsadm to create configdb and use options for AD
account creation. I always get the unhelpful message, "SQL Server 2000
Service Pack 3 or later is required", but of course my SQL Server has SP4.
Can someone please tell me what options I should use for stsadm?
I have:
Windows 2003 Server as a domain controller and host of SQL Server 2000 SP4
and Active Directory. All service packs current.
Windows 2003 Server as SharePoint host, nothing else installed.
It appears the SP install is OK (yes, I used remotesql=yes). The application
pool for admin site is running, and I followed instructions for user accounts
- local admin as well as admins in AD. But I had to add STSFLTR manually to
the ISAPI filter list for Default Web Site (probably because I installed
remotesql=yes).
But when I get to "stsadm -o setconfigdb ..." that's when I get the stinkin'
SQL error. Again, what options should I be using? I didn't use -du -dp,
because I've never seen an example where -du -dp are used. I assumed I had
setup admin users correctly to handle the tasks ... but maybe I should
specify user/passwd? Unfortunately can't try this now, and can't messages
from work (Passport login is blocked!).
--
-----
Glenn Nelson in Santa Cruz |
|
| Back to top |
|
 |
Ian Morrish
Guest
|
| Posted:
Wed Nov 09, 2005 9:51 am Post subject:
Re: FAILURE installing WSS with Active Directory auth |
|
|
Hi,
IIS App Pools should be running under Domain Account (not system or
network). SQL Server should also be running under a Domain Account.
Did you add IIS after the server was promoted to a DC? (will not work if IIS
was installed before promotion)
Regards,
Ian
http://www.wssdemo.com
"Glenn Nelson" <GlennNelson@discussions.microsoft.com> wrote in message
news:C9B8E2E6-5033-4AE1-A676-1879FF608B37@microsoft.com...
| Quote: | I asked a question about setconfigdb (on Nov. 7), got no replies. I'm
REALLY
stuck. I'm trying to use stsadm to create configdb and use options for AD
account creation. I always get the unhelpful message, "SQL Server 2000
Service Pack 3 or later is required", but of course my SQL Server has SP4.
Can someone please tell me what options I should use for stsadm?
I have:
Windows 2003 Server as a domain controller and host of SQL Server 2000 SP4
and Active Directory. All service packs current.
Windows 2003 Server as SharePoint host, nothing else installed.
It appears the SP install is OK (yes, I used remotesql=yes). The
application
pool for admin site is running, and I followed instructions for user
accounts
- local admin as well as admins in AD. But I had to add STSFLTR manually
to
the ISAPI filter list for Default Web Site (probably because I installed
remotesql=yes).
But when I get to "stsadm -o setconfigdb ..." that's when I get the
stinkin'
SQL error. Again, what options should I be using? I didn't use -du -dp,
because I've never seen an example where -du -dp are used. I assumed I had
setup admin users correctly to handle the tasks ... but maybe I should
specify user/passwd? Unfortunately can't try this now, and can't messages
from work (Passport login is blocked!).
--
-----
Glenn Nelson in Santa Cruz |
|
|
| Back to top |
|
|
Glenn Nelson
Guest
|
| Posted:
Thu Nov 10, 2005 9:51 am Post subject:
Re: FAILURE installing WSS with Active Directory auth |
|
|
Problem solved! It was actually a failed installation of SQL Server 2000 SP4.
Our sysadmin tried to install it twice - and saw no indication that it had
failed. However, checking on the version number of SQL Server, I saw that it
had NO service packs installed. So sysadmin then tried SP3, followed by SP4.
This time OK.
And then I was able to perform setconfigdb operation.
--
-----
Glenn Nelson in Santa Cruz
"Ian Morrish" wrote:
| Quote: | Hi,
IIS App Pools should be running under Domain Account (not system or
network). SQL Server should also be running under a Domain Account.
Did you add IIS after the server was promoted to a DC? (will not work if IIS
was installed before promotion)
Regards,
Ian
http://www.wssdemo.com
"Glenn Nelson" <GlennNelson@discussions.microsoft.com> wrote in message
news:C9B8E2E6-5033-4AE1-A676-1879FF608B37@microsoft.com...
I asked a question about setconfigdb (on Nov. 7), got no replies. I'm
REALLY
stuck. I'm trying to use stsadm to create configdb and use options for AD
account creation. I always get the unhelpful message, "SQL Server 2000
Service Pack 3 or later is required", but of course my SQL Server has SP4.
Can someone please tell me what options I should use for stsadm?
I have:
Windows 2003 Server as a domain controller and host of SQL Server 2000 SP4
and Active Directory. All service packs current.
Windows 2003 Server as SharePoint host, nothing else installed.
It appears the SP install is OK (yes, I used remotesql=yes). The
application
pool for admin site is running, and I followed instructions for user
accounts
- local admin as well as admins in AD. But I had to add STSFLTR manually
to
the ISAPI filter list for Default Web Site (probably because I installed
remotesql=yes).
But when I get to "stsadm -o setconfigdb ..." that's when I get the
stinkin'
SQL error. Again, what options should I be using? I didn't use -du -dp,
because I've never seen an example where -du -dp are used. I assumed I had
setup admin users correctly to handle the tasks ... but maybe I should
specify user/passwd? Unfortunately can't try this now, and can't messages
from work (Passport login is blocked!).
--
-----
Glenn Nelson in Santa Cruz
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in