[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Problem accessing Sharepoint when changing local admin password on DB

I have a WSS 3.0 server (on Win2003) with the DBs being hosted by a separate DB server (SQL2000 on Win2003). I have dedicated windows users for everything - SQL2000 services, WSS services, access to the WSS DBs, etc and the local administrator is not used anywhere. However if I change the local admin password on the DB server, my Sharepoint stops working (404 error). The DB is still running (I have other websites using the same DB server and they are fine) so this is Sharepoint-specific. It looks like the (old) DB-server password is somewhere deep in the Sharepoint configuration. Any ideas where to look? I tried various places in the Central Admin but didn't see anything. thanks.
0
adneprov
Asked:
adneprov
  • 2
1 Solution
 
mccarthybriCommented:
I would look in iis, application pools.  I would also look at the services and see if that account was running anything.  Sharepoint requires that the local admin account has access to the dbs.  I would also look into the users of the db itself
0
 
mccarthybriCommented:
0
 
MsShadowCommented:
use the command

stsadm -o updatefarmcredentials -userlogin domain\user -password password

If you have a farm you need to do this on ALL your servers.
0
 
adneprovAuthor Commented:
Found the culprit in the application pool for the sharepoint website then changed it in Operations | Service Accounts | Web App Pools. Thanks!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now