.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Scale out search service application

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint

I have 2 WFEs and 1 App server running sp2010. I want my WFEs to provide query role for the farm and Application server (APPServer) will be used as index server. Can someone please help me to figure out if this is the right configuration if not what will be the best configuration. How can I assign query roles and index roles to the servers in the farm. Thanks



         Administration component                   running on APP Server


View Complete Post

More Related Resource Links

SharePoint 2010 Search Service Application: "All Content" scope contains 0 items?

I've encountered a nasty bug in our setup. Our Search Service Application manages to crawl all content just fine. However, the scopes don't work. We've got a total of 570 items currently in our crawl database. 350 of these are of class 'People', and appear in the 'People' scope. The remaining 220 items should appear in 'All Content' as part of the intra (sites, documents etc), however the 'All Content' scope reports 0 items. I've tried the following: -Creating custom scopes (still 0 items) -Recreating the Search Service Application twice -Tried different accounts as the content access account. -Ensuring that the content access accounts do have 'full read policy' -Checked the crawl log for successful content (such as sites and documents). However, despite my efforts I still get 0 items for 'All Content'.  Has anyone else encountered this problem, or do you have any recommendation for us? Currently I don't see any other option than to reinstall everything.

problem rename sharepoint 2010 search service application admin database

Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Access denied to Search Service Application

I just "upgraded" my installation of SharePoint 2010 Foundation with Search Server Express 2010.  During the installation, I was able to access and configure the Search Service Application. However, a day later, I cannot access the application management page: I get an access denied error.  I am the farm administrator, so supposedly I am supposed to have access to the management page.  I've also tried adding my login to the "Full Control" group of the Search Application; it gives me the same error.  It appears that the only account that can access the administration page is the service/system account.  Obviously this would not be ideal. I've tried looking around for logs to see if anything is amiss, but there appears to be nothing logged. What gives?  How do I fix it?

Search Service Application missing in SharePoint 2010

I installed SharePoint 2010 (Enterprise edition), enabled Enterprise features but it is missing Search Service Application when I look under Central Administration > Application Management > Manage Service Application.   When I click on New it doesn't even list "Search Service Application".    When I goto Upgrade and Patch Management > Check Product and Patch Installation Status, it tells me that "Microsoft Search Server 2010 Core" was Installed.  Under Manage services of server, "Sharepoint Foundation Search" is started.  Does anyone have an idea why the "Search Service Application" is missing and how can I install it?

Search Service Application missing in SharePoint 2010

I installed SharePoint 2010 (Enterprise edition), enabled Enterprise features but it is missing Search Service Application when I look under Central Administration > Application Management > Manage Service Application.   When I click on New it doesn't even list "Search Service Application".    When I goto Upgrade and Patch Management > Check Product and Patch Installation Status, it tells me that "Microsoft Search Server 2010 Core" was Installed.  Under Manager services of server, "Sharepoint Foundation Search" is started.  Does anyone have an idea why the "Search Service Application" is missing and how can I install it?

Search Server Express 2010 - Access Denied when attempting to manage Search Service Application or P

I first noticed this error with the Search Service Application when I was no longer able to use the search portal, but have since noticed the issue with the PowerPoint Service Application.  When I navigate in Central Administration to either the "Farm Search Administration" or the "Manage service applications" pages and attempt to manage the "Search Service Application", I get this error: Error: Access Denied  Current User You are currently signed in as:  WHEELERS\MyUserName   Sign in as a different user    I have tried removing the service application and re-adding it, changing the application pool to running under an existing application pool as the farm administrator, as another application pool with the same identity as the primary web application, and as another application pool running under the SP-SearchService identity. The big recent change with SharePoint, aside from fixing the previous issue where I was incorrectly using CNAMEs with Kerberos, was to switch the main web application to claims authentication. That site correctly works with claims based authentication and Kerberos.

Force deletion of Search Service Application

Hello, we have a farm consisting of 5 servers. The server hosting the search services instances (admin component, search component, query component) crashed. The crashed server has been removed from the farm (manage servers, remove server). How can we get rid of the Search Service application? When we try to delete it, the job runs for hours (Processing, please wait.....) but never finishs? Thanks a lot for help Christoph

Search server 2010 setup - error creating search service application

I am running in a very similar siutation as this post:

I am configuring a new Search Server 2010 production environment.

I used the search setup account to run the setup and run the SharePoint Products Configuration Wizard.

During the first run of the SharePoint configuration wizard (where the farm account and service applications are setup), the process failed because the search service application could not be created.  

Errors were encountered during the configuration of the Search Service Application.
System.Data.SqlClient.SqlException: User does not have permissiont to perform this action.

I was under the assumption that the setup account had securityadmin and dbcreator SQL Server roles.  However, this was not the case and I had them added.  My original thought was the setup failed because of this.  After those roles were added, I tried to recreate the search service application and I still get a failure.

I am pretty sure I have followed the prerequisites as prescribed by Microsoft in terms of account setup (

Custom search queries not logging except to Search Service Application



I have written custom web controls that run specialised search queries under SharePoint Server 2010, using both FullTExtSQL syntax and (more recently) Keyword syntax, using both the object model and the Search web service.

Unlike the OOTB microsoft search webparts, which log to the web analytics section of the individual site collections, my controls only log the queries performed to the Web Analytics section of the Search service application (within Central Administration).

I have looked at the OOTB webparts using relflector, and followed the Federated search process for how the queries get logged, and I can't see any reason why my controls are ignored. (The QUeryInfo object is built and the information logged when the Query is executed, so it should be done when my custom queries are executed.)

Could anyone enlighten me as to what is going on here?




search service application:Query component error


I tried to create a new query component using powershell commands

PS C:****> $ssa = Get-SPEnterpriseSearchServiceApplication
PS C:****> $qtOld = $ssa | Get-SPEnterpriseSearchQueryTopology -Active
PS C:****> $ssInstance = Get-SPEnterpriseSearchServiceInstance -Local
PS C:****> $qtNew = $ssa | New-SPEnterpriseSearchQueryTopology -Partiti
ons 1
PS C:****> $idxPartition = (Get-SPEnterpriseSearchIndexPartition -Query
Topology $qtOld)
PS C:****> $queryComponent = New-SPEnterpriseSearchQuerycomponent -Quer
yTopology $qtNew -IndexPartition $idxPartition -SearchServiceInstance $ssInstanc


and I am getting the following error:

New-SPEnterpriseSearchQueryComponent : Query component can be created only for
partition from the same topology.
At line:1 char:55
+ $queryComponent = New-SPEnterpriseSearchQuerycomponent <<<<  -QueryTopology $
qtNew -IndexPartition $idxPartition -SearchServiceInstance $ssInstance
    + CategoryInfo          : InvalidData: (Microsoft.Offic...hQueryComponent:

Search service application - Query component


In my search service application the 'query component' is stuck on the 'initialzing' status.So I googled to fix that error and found an article.


below the heading search fix.But I have some doubts regarding that.


In that post it has mentioned about the 'SetupEnterpriseSearch.ps1' and the configuration file 'searchconfig.xml'.

As mentioned in the first step of that article : How can i load the SetupEnterpriseSearch.ps1 to the powershell and what all things I need to change inside that file.Can anyone please explain that in detail.

In the second step : Execute “Start-EnterpriseSearch “<path> \searchconfig.xml”" what is the path that need to be specified and what all things have to be changed inside that config file.

Please help .Thanks in advance.


Not able to delete Search Service Application


I am not able to delete the Search_Service_Application-New,

proxy is already deleted, but the service still exists, did check the database , both crawlstoredb and propertystoredb are deleted for that service.

I have tried all the commands using powershell, checked all the app pools, all the realted app pools are deleted, did a psconfig did not help

Below is the error when i tried to delete


Cannot open database "Search_Service_Application_New_DB_b0e96923863f4a48bbf222ad91d5f7f8" requested by the login. The login failed.
Login failed for user 'domain\SPDevelFarm'.


Troubleshoot issues with Microsoft SharePoint Foundation.

I see the service still exists, databases does not exist, proxy does not exist, I need to delete it from the services

Thank you

Cannot crearte new search service application


Cannot create new search service application, I am getting below error, I have deleted all the app pools related to that service, still it is saying the app pools exist


An unhandled exception occurred in the user interface.Exception Information: An object of the type Microsoft.SharePoint.Administration.SPIisWebServiceApplicationPool named "SSATest" already exists under the parent Microsoft.SharePoint.Administration.SPIisWebServiceSettings named "SharePoint Web Services".  Rename your object or delete the existing object.


Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: a8c8dc3e-f5c7-4b42-b990-764e02f52de0

Date and Time: 10/14/2010 5:50:42 PM

Search Service Application creation causes DB errors in SharePoint Logs

When I add a Search Service Application in CA, I receive database errors in the LOG files related to permissions.  The service account is the same as the Farm service account in this case, which does have the db_owner role for the Search Service databases.  I have tried re-installing SharePoint Server 2010 three times.  The first two, I was using a service account that had less rights and failed to create the Search Service Application databases.  Using the Farm service account, I was able to create the Service, but still getting the errors mentioned below. 

01/11/2010 09:44:30.65  OWSTIMER.EXE (0x09A8)                    0x0C20 SharePoint Foundation          Database                       880i High     System.Data.SqlClient.SqlException: The user does not have permission to perform this action.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 

Issue with creating a new Search Service Application


I am new to SharePoint, so please bare with me.


1)      Installed SQL Server 2008 on a virtual machine

2)      Installed SharePoint Server 2010 on another virtual machine and configured it in a Farm environment. Installed and configured FAST search successfully on this same machine.

3)      One of the initial steps for post installation of FAST Search states that we have to create a new Search Service Application.

a)      Tried to create a New Search Service application using the following steps: 

i)                    From the Microsoft SharePoint Server Central Administration home page, select Application M

Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Adm

Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (3ea4ace8-84f5-4d62-9c73-1325698a045a).

Reason: Logon failure: unknown user name or bad password

Techinal Support Details:
System.ComponentModel.Win32Exception: Logon failure: unknown user name or bad password
  at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.SynchronizeDefaultContentSource(IDictionary applications)
  at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize()
  at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)

Above exception appears every minute in windows logs. Your help is appreciated.


Apriori algorithm [association rule]

Search Service Application error in SharePoint 2010


Help with error

·          Small SharePoint farm (single server)

           ·          (not a stand alone/other servers can be added later)

·          SharePoint 2010 and SQL 2008 are on the same server

·          Administrative Domain User account: SharePoint Administrator

·          SharePoint Administrator is in the Administrator group on the local server

Error log

           Count Error                Message

1)        3              -               Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has &quo

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend