Solved

SP2010 Timer Service

Posted on 2014-07-24
22
400 Views
Last Modified: 2014-07-29
Application: SharePoint 2010
Description: The Execute method of job definition Microsoft.Office.Server.Search.Administration.IndexingScheduleJobDefinition <guid> threw an exception.
"The password of the search service account has expired.  To update the password visit the services on server page and  update the password for the search service".
Symptom:
1. Users cannot make changes to calendar items although they have contribute permission level.  No change made to their permission level at all.  As a workaround, I have to make changes locally on the server, when user(s) request for changes to be made.
Steps taken so far:
1. reset IIS
2. went to Central Admin > Security > Configure Managed Accounts and checked settings.  Looks normal.
Any advice provided is appreciated.
0
Comment
Question by:francismichael
  • 11
  • 11
22 Comments
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
looks like the search service authentication has failed.
follow below to setup/change service applications authentication/passwords the right way.
http://blogs.technet.com/b/seanearp/archive/2011/01/25/updating-passwords-on-sharepoint-2010.aspx
0
 

Author Comment

by:francismichael
Comment Utility
Jaya,
I went through this blog as well as Todd Klindt's blog.  For my server, I have taken a screenshot of "configure service accounts" page.  All services are managed by domain\SQLAdmin.  I don't understand where the change is to be made.  Please advice.  See screenshot.
Screenshot-on-Timer-and-password-issues-
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
Go to CA,
Under General Security, click Configure managed accounts.
 Click the Edit button next to the account that you want to change in your case its domain\sqladmin.
In the Credential Management section of the resulting page
click the checkbox next to change password and then choose set account password to new value and save it. allow it few mins for the effects to take place.
0
 

Author Comment

by:francismichael
Comment Utility
I did as instructed.  Now unable to connect to CA.  See screenshots.
Error--2.png
Error--1.png
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
whats your farm admin account ? does that have entry in sql server ?
make sure this account domain\sqladmin is having db owner acces on the sql server. if not please add it. once you are able to connect to ca then change the settings of the sql permission as documented
or
look at the apppool the ca is running, revert it back to the identity which its running initally and you shoulbe be able to connect and also ensure
a. Click Start->run->input "Services.msc"(no quotation) in prompt command.
b. Right click SQL Server(SHAREPOINT) services->Properties->click Log On Tab
c. Select 'Log on as Local System account' option.
d. Start the SQL Server(SHAREPOINT) services normally. how about the results?
0
 

Author Comment

by:francismichael
Comment Utility
1. Farm Account is SP_Farm
2. Yes, SP_Farm has an entry in SQL server
3. domain\sqladmin has access as dbcreator
4. Cannot connect to CA
5. I cannot log into SQL Server
Please advice.
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
switch the account (app pool identity) back to sp_farm account.
Also make sure of the service applications(services.msc) sharepoitn ones to run on sp_farm account
0
 

Author Comment

by:francismichael
Comment Utility
When I attempt to connect to Microsoft SQL Server Management Studio (2012) using the following:
1. Server Type: Database Engine
2. Server Name: SQL
3. Authentication: Windows Authentication
I get error, see screenshot.  I tried logging into SQL using SP_Farm account without any success.  Looks like I'm locked out of SQL.  Please advice.
connect-to-sql-error-message.png
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
ok so looks like the sp_farm account is your farm account. and the account sql dosent have proper rights to access the content db.
change the application pool identity of the central administaion and the web application to sp_farm account , you should be able to connect

+ here are some troubleshooting steps http://snahta.blogspot.com/2008/08/cannot-connect-to-config-db.html
0
 

Author Comment

by:francismichael
Comment Utility
OK.  
1. I can connect to (and log into) MS SQL Server Management Studio. Thank you.  (Note SQL is on a separate server).
2. When I go to my SharePoint Server and start SharePoint 2010 Central Administration, I get the following message, viz. "Cannot connect to the Configuration Database".  
3. What next?
Francis
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
PS note my comment : change the application pool identity of the central administration and the web application to sp_farm account , you should be able to connect

1. Click Start --> Run--> Type inetmgr
2. Double-click the Web Sites folder.
3. Right-click the virtual server that is running WSS and then click Properties.
4. Click Home Directory.
5. Note the information that is in the Application name box (this is the application pool name), and then click Cancel.
6. In the left pane, right-click Application Pools, and then click Properties.
7. Click the Identity tab.
8. Note the information that is in the Application pool identity pane, and then make sure its sp_farm not sql.
0
Too many email signature changes to deal with?

Are you constantly being asked to update your organization's email signatures? Do they take up too much of your time? Wouldn't you love to be able to manage all signatures from one central location, easily design them and deploy them quickly to users. Well, you can!

 

Author Comment

by:francismichael
Comment Utility
OK.  Central Admin is connected!.  Can access SharePoint via web browser.  Looks like we are back to square one.  Do I repeat steps suggested before?  Or do you suggest something else.  The original issue, see first request for help remains open.  Here are two screenshots of error messages from browser.  Screenshot A shows that uses can access SharePoint using IP address not domain friendly name.  Screenshot B shows error when user tries to open a folder (user has full access to folder).  Screenshot C is the original screenshot sent earlier which shows what happens when a user tries to add an item to the calendar.  (User has full access to calendar).  Please advice.
Thank you.
Screenshot-A.png
Screenshot-B.png
Screenshot-C.png
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
two different issues.
1. you request was an error for changing service account passwords. If that needs to be done
change query server From app to WFE Server and also updated search service account password after that search should be working.

2.you need to configure AAM /host header to resolve your domain name instead of IP. If you use the domain name B and C should be resolved
0
 

Author Comment

by:francismichael
Comment Utility
1. Please give "how to" for "change query server From app to WFE Server".  Will same issue arise if I update search service account?
2. the second issue, viz IP instead of DNS is minor issue.  Will follow configuration of AAM / host header method.
Advice on item 1, please.
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
go to CA, services on server which ll end up in /_admin/Server.aspx.. then from there drop down the server names and pull up app server and in that "Search Query and Site Settings Service " stop on app server and start on web server. and then do a full crawl
0
 

Author Comment

by:francismichael
Comment Utility
On CA, under server name, I only  have SharePoint WFE and SQL.  (It is 2 tier set-up). Web Server and App Server are the same.  Does that make a difference in stop / start "Search Query and Site Settings Service".  Thanks.
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
yes it will try to stop and start the search query and site settings.
also restart sharepoint search service from services.msc
0
 

Author Comment

by:francismichael
Comment Utility
Do you know Powershell?  See error message in screenshot showing password recognition.  I wonder if this will resolve Timer / Search issues.  Any advice?
Error-when-trying-to-start-Search-Servic
0
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
looks like the passwords got changed from AD and SP stored password is different.
To fix this issue do the following
Logon to the SharePoint 2010 server as an admin, preferably as the account used to install SharePoint
Open up the SharePoint PowerShell command prompt
Set-SPManagedAccount -UseExistingPassword -Identity CISSA\cisadmin
You will then be prompted for the existing\new password for "CISSA\cisadmin"
Run "Repair-SPManagedAccountDeployment" to verify the passwords are now in sync
0
 

Author Comment

by:francismichael
Comment Utility
Jaya,
1. Ran PS cmdlet as requested.
2. Provided new pwd for cissa\cisadmin
3. Ran "Repair....."
4. No problems reported in PS.
5. Stop / Start - search service
6. ran iisreset

Final result - issue unresolved.  User cannot make change to calendar.  Error remains.  User cannot make changes to calendar.
0
 
LVL 8

Accepted Solution

by:
Jayaraja Jayaraman earned 400 total points
Comment Utility
As i said above its a different issue.
for "The password of the search service account has expired.  To update the password visit the services on server page and  update the password for the search service" the issue is resolved.

This has nothing to do with the calendar. Please close this and create a separate thread for the calendar issue going on.
Did you setup aam ?  .
0
 

Author Closing Comment

by:francismichael
Comment Utility
OK.  AAM have been set up and access to sharepoint is done to IP not domain names.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now