Individuals sporadically receive Access is denied to Sharepoint Site

Event Type:      Error
Event Source:      Windows SharePoint Services 3
Event Category:      Database
Event ID:      3351
Date:            4/28/2010
Time:            10:30:13 AM
User:            N/A
Computer:      SharepointServer
Description:
SQL database login failed. Additional error information from SQL Server is included below.

Login failed for user 'DOMAIN\username'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Error is preceded by Event ID 18456:

Event Type:      Failure Audit
Event Source:      MSSQL$MICROSOFT##SSEE
Event Category:      (4)
Event ID:      18456
Date:            4/28/2010
Time:            10:30:13 AM
User:            DOMAIN\username
Computer:      SharepointServer
Description:
Login failed for user 'DOMAIN\username'. [CLIENT: <named pipe>]


This happens for several users but not every time.
LVL 1
bfowler3Asked:
Who is Participating?
 
bfowler3Connect With a Mentor Author Commented:
The issue has been resolved.  Received a script from Microsoft that updated username password in iis.  Just replace %username% and %password% with your own passord.

@echo off
rem other app pools
echo *** Updating app pool passwords
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o updateaccountpassword -userlogin %username% -password %password% -noadmin
rem central admin
echo *** Updating Central Admin password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o updatefarmcredentials -userlogin %username% -password %password%
rem ssp - new
echo *** Updating ssp password for new installs
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o editssp -title "SharedServices1" -ssplogin %username% -ssppassword %password%
rem ssp - upgrade
echo *** Updating ssp password for upgraded installs
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o editssp -title "Default Web Site" -ssplogin %username% -ssppassword %password%
rem osearch
echo *** Updating osearch password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o osearch -farmserviceaccount %username% -farmservicepassword %password%
echo *** MANUAL UPDATE NEEDED. To update the password, visit the SSP Web application page, click Search Settings, and then click Default Content Access Account.
rem spsearch
echo *** Updating spsearch password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o spsearch -farmserviceaccount %username% -farmservicepassword %password%
echo *** Updating spsearch content access account
"%commonprogramfiles%\Microsoft Shared\web server extensions\12\BIN\stsadm.exe" -o spsearch -farmcontentaccessaccount %username% -farmcontentaccesspassword %password%
rem restarting IIS
echo *** Doing soft restart of IIS
iisreset /noforce
echo on
0
 
quihongCommented:
Strange. SharePoint uses the AppPool account to connect to the SQL DB not the individual user.
0
 
bfowler3Author Commented:
script reset IIS account passwords
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.