.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

Search Service Application creation causes DB errors in SharePoint Logs

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint
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) 

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

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 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

Using SharePoint Search feature in ASP.Net Application

Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

User Profiles Service Application and Import of SharePoint 2007 SSP data

I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

SharePoint Server 2010 Search - not returning results but crawling without errors

I have created a Search Service Application on a SharePoint Server 2010 (RTM) Farm and used the default Content Source. I started a Full Crawl and it suceeded with no errors etc. I ran it a few times and no issues. But if I go to the Intranet Portal Web Appliaction and do a search for a document that would have been crawled it does not show up in search results...nothing does. I am not getting any errors in Event Log or ULS Logs relevant to Search. How can I troubleshoot this problem further?SharePoint Solution Architect, Perth Australia - Microsoft Virtual Technology Specialist - MCTS WSS Dev, WSS Adm, MOSS Dev, MOSS Adm - http://wss.made4the.net/ - Founder of http://www.sharepointdevwiki.com/

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?

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

How to Programatically SetCredentials for Secure Store Service Application in Sharepoint 2010 using

I have to setup Credentials for Secure Store Service application programatically. To get Stored Credentials I have following code and its working fine. using (SPSite site = new SPSite("http://vtlssp2010Dev")) //using (SPSite site = new SPSite("http://" + System.Environment.MachineName + "/sites/Site_Name"))d { Console.WriteLine(site.RootWeb.CurrentUser.Name); SPServiceContext context = SPServiceContext.GetContext(site); prov.Context = context; try { SecureStoreCredentialCollection cc = prov.GetCredentials(appID); foreach (SecureStoreCredential c in cc) { IntPtr ptr = System.Runtime.InteropServices.Marshal.SecureStringToBSTR(c.Credential); string sDecrypString = System.Runtime.InteropServices.Marshal.PtrToStringUni(ptr); Console.WriteLine(sDecrypString); } } catch (Exception ex) { Console.WriteLine("Unable to get credentials for application " + appID); Console.WriteLine(ex.Message); } Console.ReadLine(); } } All I want is to programmatically do set credentials like explained in this example on msdn. http://msdn.microsoft.com/en-us/library/ff798456.aspx Please help. Shamshad Ali  

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.

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??

Trying to build a custom application to crawl SharePoint Search

Hello,      I have been tasked with building a custom application to develop a report dynamically based upon a search ran in a SharePoint site using user-defined keywords. What I need the application to do is this: 1.) Access the results of a search, and do a full fidelity save of each item. 2.)  If the item returned is a document in a library and it has other versions associated with it, access the meta-data of those other versions and group those results with the item found in the search. 3.) Store the results in XML (probably the easiest), and build a custom display for reporting purposes. If anyone has any advice on how I can accomplish this, I would be very grateful, Thanks!

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

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
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