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

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

Manually specify database name for Microsoft SharePoint Foundation Search Service Settings

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

Hi Team,

I wanted to specify database name manually for Microsoft SharePoint Foundation Search Service under Application management | Manage services on server | Sharepoint Foundation Search . Under Search database settings,  it says 'Use of the default database server and database name is recommended for most cases. Refer to the administrator's guide for advanced scenarios where specifying database information is required.' . Specifying database name field is coming grayed out and can't have option to specify my own database name. Any help to specify database name for foundation search will be highly ppreciated.





View Complete Post

More Related Resource Links

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

Team Foundation Server and WSS 3.0 SharePoint Service Search not visible

I am having issues with setting up SharePoint Search service on the TFS 2008 server WSS 3.0. The Windows SharePoint Service Search service doesn't appear in Central Administration>Operations>Services on Server page. Only the Central Administration, Windows SharePoint Services Incoming E-Mail, and Windows SharePoint Services Web Application appear. I have Windows SharePoint Service Search running through Services in Windows and still it doesn't appear on the page to configure it. The service account that this service running under has db_reader role access to the WSS_Content database and is a db_owner for the WSS_AdminContent and WSS_Config database as well as for the WSS_Search database. I have executed iisreset and even rebooted the server to no avail. The installation/set up of TFS was done prior to me join the team. It was a default set up with dual servers. The Event Logs show nothing out of the ordinary to help me troubleshoot the issue. Does anyone have any other suggestions I should try or other things I should be looking for? Thank you in advance, WillWill Piedmont

The Select Microsoft SharePoint Foundation search server drop down is greyed out.


I am trying to select a server that is running the Microsoft SharePoint Foundation search service but the drop down is disabled.  I have verifed that that SharePoint Foundation Search V4 is started.  But when I go to Central Adminstration > Manage Content Database Settings > and choose my content database it won't let me select a search server.  I only have one SharePoint Server so the search service is local.

Thank you

Increasing search result count from "10000" to "100000" in Sharepoint Foundation with Microsoft Sear



How to increase the search results count from "10000" to "100000" for Sharepoint Foundation with Microsoft Search Server Express Installed in it. Please help us.

Thanks & Regards,


Microsoft SharePoint Foundation 2010 Beta - Now Available!

This download contains an installable version of SharePoint Foundation 2010 Beta that can be used to assess and test the new functionality in this release. SharePoint Foundation 2010 is the new version of Windows SharePoint Services.

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 With SharePoint Designer 2010 and the Search.asmx Web Service

I've created a web service datasource on a 2010 site using SharePoint Designer. When I try to make use of the datasource on a page I get the "The server returned a non-specific error when trying to get data from the data source..." message. The datasource connects to _vti_bin/search.asmx. I am using the QueryServiceSoap port and operation QueryX. I've tried various queryXml strings, including site & people searches using both SQL and keyword syntax. eg <?xml version="1.0" encoding="utf-8" ?><QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000"><Query domain="QDomain"> <SupportedFormats><Format>urn:Microsoft.Search.Response.Document.Document</Format></SupportedFormats> <Context>   <QueryText language="en-US" type="MSSQLFT"><![CDATA[ SELECT Size, Rank, Path, Title, Description, Write, Filename, Description, Author FROM scope() WHERE CONTAINS ('"Lorum"') AND  ( ("SCOPE" = 'All Sites') )   ORDER BY "Rank" DESC ]]></QueryText> </Context> <Range><StartAt>1</StartAt><Count>20</Count></Range> <EnableStemming>false</EnableStemming> <TrimDuplicates>true</TrimDuplicates> <IgnoreAllNoiseQuery>true&l

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?

Sharepoint 2010 Search service removal and reinstall

In my attempt to recover from a database restore to a new server I was able to get most of the functionality to work with the data that was in my restore.  However Search service was not able to get connected and since it was a new install there should not have been much in the search database so it was not important enough to try and figure out the issue.  So, I stopped the Foundation search service with no problem and then tried to stop the search service and it gave me  the following message stating :   Removing the search service from a server must be done within the context of a search service application.  To temporarily reclaim resources used by the search service, Vist the Content Sources page and select "Pause all Crawls."  To unprovision the search service from this machine, modify the topology of each search service application and remove all components from this server.  Click OK to go to the Manage Service Applications page where you can select a Search Service Application to Configure.  deleted the service app and tried to reinstall the search service since this was a new install to begin with however I could never get the regular service to start correctly. However there was no search service installed in the services section.  It would not allow me to stop the service which is under the Ce

SharePoint 2010 search service always been disabled

am working with SharePoint 2010 Enterprise edition with windows server 2008 R2, and I installed SQL Server 2008 R2 in the same machine.... my problem is that the OS always disable both services of Sharepoint Server Search 14 and Sharepoint Foundation Search V4, I tried all the ways to make them automatic and always started but i will works for 10-15 minutes them disabled again... I run sharepoint configuration wizard many times if it could to solve this issue but it sucessed with no errors but the search service issue still there... whats going wrong??

Sharepoint Search and Secure Store Service not working

Hi There I am having issues with a few Sharepoint Services When I try to search for a document on any SharePoint site, I recieve an "Internal Server Error Exception". However when I checked the log files, I couldn't find any error messages matching with the given correlation ID. The search was working 2-3 weeks ago. Also 2 weeks ago, I started receiving warnings in the Health Analyzer saying “The Security token service is not available”. I am wondering if the security token service breaking down is related to the search issues, and if so what suggestions I could try to fix this issue. I am also unable to access the secure store service. In Central Administration->Application Management->Manage Service Applications, I try to click on the Secure Store Service, but there is no Proxy attached to the service, and I receive a message “No Secure Store Service Application Proxy ID was found”. When I check the Logfile, I receive these errors: 08/10/2010 11:11:32.94               w3wp.exe (0x18E4)                                      0x0ADC SharePoint Foundation     &nb

Does not appear to have Microsoft SharePoint Foundation installed

I am on Windows 7 64 bit with local SharePoint setup and working.  When I open SharePoint designer to connect to a site I get the error "Does not appear to have Microsoft SharePoint Foundation installed". I can view the folders however when I try to connect I get this error. I am accessing via Does not appear to have Microsoft SharePoint Foundation installed. I am connecting 'open site' - entering http://{machine node name} and hitting enter.   Ideas? (thanks)dave

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

Sharepoint Search Service is running but no results

Hi,   I am new in working with Sharepoint. I recently installed the sharepoint foundation 2010 on a windows server 2008 machine. The sharepoint installed properly and the Sites are working fine. But I just cannot make the Sharepoint Search feature (using the search from the search bar). It always returns no results found. The Sharepoint foundation Search service is started. Also I cannot find the "Search Service" link under the Manage Service applications tab. Did I do anything wrong while installing Sharepoint. Also it will be very helpful if someone can point to a resource where the details about the Search Installation process and working is explained. Thanks

Sharepoint foundation search function

On my homepage, after giving a search command in the general search box, the page says there is no indexing function applyed. I have looked through the site settings and central administration but cant find anything related. Take note this is on sharepoint foundation, not sure if that makes a difference or not. Thanks

Why is it looking for: Microsoft.SharePoint.Search version when I'm installing SharePoint

I had SharePoint 2010 installed on Windows 2008R2 test box. I then upgraded it to a DC, and it broke SharePoint. In the meantime, I was asked to put SharePoint 2007 on, as a non-Microsoft SharePoint add-on that we want to test is not yet compatible with SharePoint 2007. I have removed every trace of SharePoint 2010 that I can find, but I am running into difficulties with configuraing SharePoint 2007. It installs successfully, but when it reaches task 2 of the SPTCW it fails. The error is: An exception of type System.IO.FileNotFoundException was thrown. Additional exception information: Could not load file or assembly 'Microsoft.SharePoint.Search, Version, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.   I know enough to know that it seems to be looking for SharePoint Search from 2010, but I have removed all traces of 2010. I'm guessing that there is a DLL or something that is from 2010 that hasn't been written over when installing SharePoint 2007, and it's calling for the Microaoft.SharePoint.Search.   I've been into c:\windows\assembly\GAC_MSIL and there is no evidence of a Microsoft.SharePoint.Search   I am hoping that I don't have to rebuild the server, but I'm pretty stuck now. I've spent 2 days on the whole SharePoint nightmare.
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