RE: [OzMOSS] RE: MOSS Search
I think you should check your crawl sources and see if you can narrow down whether it is a particular web app that is causing you the dramas. Access Denied may not be about user permissions, but things like IP restrictions on web applications being indexed. Log into a workstation using the crawler account and then hit each site listed in the crawl sources. Is this a single server farm or is there a dedicated crawl server? I have seen SSP web applications configured so that only loopback 127.0.0.1 can access them, and then of course when a indexing server tries to hit it, it complains of access denied. Or remove your sources altogether and add them back one by one. Thats a wild guess, granted, but check the IIS logs for the web apps and check the subcodes for the 404 errors. That might give you some more hints.. Regards Paul p.s, this issue also below (from the deep recesses of my docco) springs to mind - not that it is this issue here, but it will explain how the indexer may be crawling the wrong server and therefore getting an access denied in my above scenario. 1.1 HOSTS file issue on MyServer Noted this regular occurring entry in the event log of MyServer Event Type:Error Event Source:Office SharePoint Server Event Category:Office Server Shared Services Event ID: 6482 Date: 6/5/2007 Time: 9:39:20 AM User: N/A Computer: MyServer Description: Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (8a566f1c-a539-4801-9c86-9daecab7e47a). Reason: Access to the path 'C:\WINDOWS\system32\drivers\etc\HOSTS' is denied. Technical Support Details: System.UnauthorizedAccessException: Access to the path 'C:\WINDOWS\system32\drivers\etc\HOSTS' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileInfo.Delete() at Microsoft.Search.Administration.Security.HOSTSFile.CleanupDedicatedGathering (Hashtable HOSTSFileMappings, StringBuilder HOSTSComments, IEnumerable obsoleteHosts, String dedicatedName, Boolean isDirty) at Microsoft.Search.Administration.Security.HOSTSFile.ConfigureDedicatedGatheri ng(SearchServiceInstance searchServiceInstance, SPServer dedicatedWebFrontEndServer, IList`1 previousWebApplicationHostNames) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchron izeDefaultContentSource(IDictionary applications) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchron ize() at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSh aredServiceInstances(Boolean isAdministrationServiceJob) http://blogs.msdn.com/jjameson/archive/2007/05/05/the-case-of-the-disappeari ng-hosts-file.aspx The reason that SharePoint on MyServer needs access to the hosts file at all, the answer is due to one of the configuration settings that you can specify for Office SharePoint Server Search. In our case, we are using a farm configuration three front-end Web servers and one SSP server. In order to minimize the impact on users, we have the index server MyServer (i.e. the SSP) crawl itself. In Central Administration, if you specify a dedicated front-end for crawling content, then a timer job is created to add an entry to the hosts file to force the Web application (i.e. the host header) to resolve to the index server. Unfortunately, instead of editing the file in-place, the developer who implemented this feature decided it would be easier to just read the hosts file, add the appropriate entries, delete the original file, and then create a new file. If your SharePoint farm account (i.e. the one that the Windows SharePoint Servers Timer runs under Domain\farmaccount) is a member of the local Administrators group then there is no problem (which appears to be how this feature was tested). However, if you adhere to the principle of least privilege then there's definitely a problem. The workaround is to grant the following permissions for the WSS_ADMIN_WPG on the %SystemRoot%\System32\drivers\etc folder: Traverse Folder / Execute File List Folder / Read Data Read Attributes Read Extended Attributes Create Files / Write Data Read Permissions From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Wednesday, 23 July 2008 3:09 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search I have tried to changing the search account to another user and now I am getting a different message. Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (The item was deleted because it was either not found or the crawler was denied access to it.) From what I can see though they have permission
Re: [OzMOSS] RE: MOSS Search
We ran into this issue and it was fixed by simply recreating the SSP from scratch after patching up fully. Apparently some revisions of MOSS have a bug that can corrupt your SSP. So: 1. delete SSP 2. fully patch up 3. recreate SSP and search indexes On Wed, Jul 23, 2008 at 6:03 PM, Paul Culmsee [EMAIL PROTECTED] wrote: I think you should check your crawl sources and see if you can narrow down whether it is a particular web app that is causing you the dramas. Access Denied may not be about user permissions, but things like IP restrictions on web applications being indexed. Log into a workstation using the crawler account and then hit each site listed in the crawl sources. Is this a single server farm or is there a dedicated crawl server? I have seen SSP web applications configured so that only loopback 127.0.0.1 can access them, and then of course when a indexing server tries to hit it, it complains of access denied. Or remove your sources altogether and add them back one by one. Thats a wild guess, granted, but check the IIS logs for the web apps and check the subcodes for the 404 errors. That might give you some more hints.. Regards Paul p.s, this issue also below (from the deep recesses of my docco) springs to mind – not that it is this issue here, but it will explain how the indexer may be crawling the wrong server and therefore getting an access denied in my above scenario. 1.1 HOSTS file issue on MyServer Noted this regular occurring entry in the event log of MyServer Event Type:Error Event Source:Office SharePoint Server Event Category:Office Server Shared Services Event ID: 6482 Date: 6/5/2007 Time: 9:39:20 AM User: N/A Computer: MyServer Description: Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (8a566f1c-a539-4801-9c86-9daecab7e47a). Reason: Access to the path 'C:\WINDOWS\system32\drivers\etc\HOSTS' is denied. Technical Support Details: System.UnauthorizedAccessException: Access to the path 'C:\WINDOWS\system32\drivers\etc\HOSTS' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileInfo.Delete() at Microsoft.Search.Administration.Security.HOSTSFile.CleanupDedicatedGathering(Hashtable HOSTSFileMappings, StringBuilder HOSTSComments, IEnumerable obsoleteHosts, String dedicatedName, Boolean isDirty) at Microsoft.Search.Administration.Security.HOSTSFile.ConfigureDedicatedGathering(SearchServiceInstance searchServiceInstance, SPServer dedicatedWebFrontEndServer, IList`1 previousWebApplicationHostNames) 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) http://blogs.msdn.com/jjameson/archive/2007/05/05/the-case-of-the-disappearing-hosts-file.aspx The reason that SharePoint on MyServer needs access to the hosts file at all, the answer is due to one of the configuration settings that you can specify for Office SharePoint Server Search. In our case, we are using a farm configuration three front-end Web servers and one SSP server. In order to minimize the impact on users, we have the index server MyServer (i.e. the SSP) crawl itself. In Central Administration, if you specify a dedicated front-end for crawling content, then a timer job is created to add an entry to the hosts file to force the Web application (i.e. the host header) to resolve to the index server. Unfortunately, instead of editing the file in-place, the developer who implemented this feature decided it would be easier to just read the hosts file, add the appropriate entries, delete the original file, and then create a new file. If your SharePoint farm account (i.e. the one that the Windows SharePoint Servers Timer runs under Domain\farmaccount) is a member of the local Administrators group then there is no problem (which appears to be how this feature was tested). However, if you adhere to the principle of least privilege then there's definitely a problem. The workaround is to grant the following permissions for the WSS_ADMIN_WPG on the %SystemRoot%\System32\drivers\etc folder: Traverse Folder / Execute File List Folder / Read Data Read Attributes Read Extended Attributes Create Files / Write Data Read Permissions From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Wednesday, 23 July 2008 3:09 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search I have tried
RE: [OzMOSS] RE: MOSS Search
Hi Paul, Thanks for shedding some light on this. Could you please explain a little further as to what is required to be done. I read the kb and its talking about resetting the index. I just wanted to confirm the steps as I really don't want to stuff up the live solution, as all hell will break loose. Regards, Trent Allday TAD Solutions | P: (03) 9018 9040 | F: (03) 9769 7561 | M: 0418 745 253 | W: TadSolutions.com.au From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Culmsee Sent: Tuesday, 22 July 2008 3:49 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Sorry guys I haven't been following this thread until now, but as soon as saw stuck on crawling it made me think of a recent problem I had with SQLSP1, maintenance plans and corrupt indexes http://www.cleverworkarounds.com/2008/07/09/office-server-search-memory-leak-and-stuck-on-crawling/ Also check the personalisation service permissions of the crawler account in the SSP. I've seen this stick because the crawler can't access the user profile store. Hope that helps Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 1:39 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Yeah correct. SQL is own its own machine. Web server on own machine. AD on own machine. All on same network and domain. My test env is on one env (nice easy :)). Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: MOSS Search
Can you also confirm that you have configured Kerberos properly in Production for SQL Server etc? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 3:32 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Hi Paul, Thanks for shedding some light on this. Could you please explain a little further as to what is required to be done. I read the kb and its talking about resetting the index. I just wanted to confirm the steps as I really don't want to stuff up the live solution, as all hell will break loose. Regards, Trent Allday TAD Solutions | P: (03) 9018 9040 | F: (03) 9769 7561 | M: 0418 745 253 | W: TadSolutions.com.au From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Culmsee Sent: Tuesday, 22 July 2008 3:49 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Sorry guys I haven't been following this thread until now, but as soon as saw stuck on crawling it made me think of a recent problem I had with SQLSP1, maintenance plans and corrupt indexes http://www.cleverworkarounds.com/2008/07/09/office-server-search-memory-leak-and-stuck-on-crawling/ Also check the personalisation service permissions of the crawler account in the SSP. I've seen this stick because the crawler can't access the user profile store. Hope that helps Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 1:39 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Yeah correct. SQL is own its own machine. Web server on own machine. AD on own machine. All on same network and domain. My test env is on one env (nice easy :)). Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Oconics Pty Ltd may contain information that is confidential and legally privileged. Please do not read, copy, forward or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it back to the sender and delete it completely from your computer system. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: MOSS Search
Yeah I can log onto the box and studio using windows auth Regards, Tremt From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Ruckert Sent: Tuesday, 22 July 2008 5:12 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Can you also confirm that you have configured Kerberos properly in Production for SQL Server etc? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 3:32 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Hi Paul, Thanks for shedding some light on this. Could you please explain a little further as to what is required to be done. I read the kb and its talking about resetting the index. I just wanted to confirm the steps as I really don't want to stuff up the live solution, as all hell will break loose. Regards, Trent Allday TAD Solutions | P: (03) 9018 9040 | F: (03) 9769 7561 | M: 0418 745 253 | W: TadSolutions.com.au From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Culmsee Sent: Tuesday, 22 July 2008 3:49 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Sorry guys I haven't been following this thread until now, but as soon as saw stuck on crawling it made me think of a recent problem I had with SQLSP1, maintenance plans and corrupt indexes http://www.cleverworkarounds.com/2008/07/09/office-server-search-memory-leak-and-stuck-on-crawling/ Also check the personalisation service permissions of the crawler account in the SSP. I've seen this stick because the crawler can't access the user profile store. Hope that helps Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 1:39 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Yeah correct. SQL is own its own machine. Web server on own machine. AD on own machine. All on same network and domain. My test env is on one env (nice easy :)). Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Oconics Pty Ltd may contain information that is confidential and legally privileged. Please do not read, copy, forward or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it back to the sender and delete it completely from your computer system. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: MOSS Search
I have looked at the index's are they all are as they are supposed to be. I checked each individually and ran the sql command and all come back as 1. I have created a new content source to see if that will have any effect, but at this stage it doesn't seem so. Can anyone offer any more advice. I am really stuck on this one. Cheers. Regards, Trent From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 5:30 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Yeah I can log onto the box and studio using windows auth Regards, Tremt From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Ruckert Sent: Tuesday, 22 July 2008 5:12 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Can you also confirm that you have configured Kerberos properly in Production for SQL Server etc? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 3:32 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Hi Paul, Thanks for shedding some light on this. Could you please explain a little further as to what is required to be done. I read the kb and its talking about resetting the index. I just wanted to confirm the steps as I really don't want to stuff up the live solution, as all hell will break loose. Regards, Trent Allday TAD Solutions | P: (03) 9018 9040 | F: (03) 9769 7561 | M: 0418 745 253 | W: TadSolutions.com.au From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Culmsee Sent: Tuesday, 22 July 2008 3:49 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Sorry guys I haven't been following this thread until now, but as soon as saw stuck on crawling it made me think of a recent problem I had with SQLSP1, maintenance plans and corrupt indexes http://www.cleverworkarounds.com/2008/07/09/office-server-search-memory-leak-and-stuck-on-crawling/ Also check the personalisation service permissions of the crawler account in the SSP. I've seen this stick because the crawler can't access the user profile store. Hope that helps Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 1:39 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Yeah correct. SQL is own its own machine. Web server on own machine. AD on own machine. All on same network and domain. My test env is on one env (nice easy :)). Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Oconics Pty Ltd may contain information that is confidential and legally privileged. Please do not read, copy, forward or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it back to the sender and delete it completely from your computer system. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: MOSS Search
Make sure that your search account has full rights under personalisation services permissions in your shared service provider From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 9:18 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search I have looked at the index's are they all are as they are supposed to be. I checked each individually and ran the sql command and all come back as 1. I have created a new content source to see if that will have any effect, but at this stage it doesn't seem so. Can anyone offer any more advice. I am really stuck on this one. Cheers. Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: MOSS Search
In your Test Environment does everything reside on the same box (i.e. SQL + SPS)? Then in Prod are components separated? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 2:25 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Correct, I am using windows authentication mode. It is a member of the same domain. I already have the account and as db owner of all databases just for testing purposes. Regards, Trent From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Tuesday, 22 July 2008 2:46 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Okay, so you're using integrated windows authentication right? And the SQL server is a member of the same domain (can authenticate against it?). I doubt that you'll need to worry about mixed mode, however it might be worthwhile turning it on for future. What you need to do, is ensure that you have actually added the account as a logon, with the appropriate access. Did you expand the 'logins' node in management studio at the top level, add the account, then in the user mappings select your database and assign it DB owner privilege? Cheers, Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 2:36 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Hi Matthew, Thanks for your response. There is nothing in the log except a couple of old entries. Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (The item was deleted because it was either not found or the crawler was denied access to it.) I have since fixed this and gave permission to the correct account. Although just to double check I tried to login to sql database using the provide account and it stipulates the following: The following knowledgebase article will help you to resolve error message Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) during SQL logon process. http://support.microsoft.com/kb/555332 Its currently not set to mixed mode but the account is an AD account...? I can try and change it to mixed mode after business hours (as would required sql reboot) but wouldn't it say 'Access is denied' in the search log? Regards, Trent From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Tuesday, 22 July 2008 1:29 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Hi Trent, I find it hard that there isn't anything being listed in the crawl logs. Can you go into 'search settings', then take a look at the 'crawl log' in there. You should be able to see the reason why it's failing (sounds like permissions.) Which account have you set up as the crawling account? Can you double check this, then make sure it does in fact have appropriate access? Cheers, Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 11:40 AM To: listserver@ozMOSS.com Subject: [OzMOSS] MOSS Search Hi, Am having a great deal of trouble trying to get the MOSS search function to work. I can get it work on my testing environment no worries but struggling on production env. Does anybody know of a good tutorial on how to turn on the search function. What I have done: * Ensured service is turned on. * Default content access account has permission to SharePoint SQL Database * Content Sources should be correct. o I have tried both internal external addresses If I tick the checkbox 'Start full crawl of this content source' it begins to crawl but the status just stays on 'Crawling Full'. Its been this way for a week! Nothing is returned in the site search. From what I can see there is nothing being returned in the logs. Could anybody point me in the right direction please? Any help would be greatly appreciated... Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the
RE: [OzMOSS] RE: MOSS Search
Yeah correct. SQL is own its own machine. Web server on own machine. AD on own machine. All on same network and domain. My test env is on one env (nice easy :)). Regards, Trent From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Ruckert Sent: Tuesday, 22 July 2008 3:21 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search In your Test Environment does everything reside on the same box (i.e. SQL + SPS)? Then in Prod are components separated? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 2:25 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Correct, I am using windows authentication mode. It is a member of the same domain. I already have the account and as db owner of all databases just for testing purposes. Regards, Trent From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Tuesday, 22 July 2008 2:46 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Okay, so you're using integrated windows authentication right? And the SQL server is a member of the same domain (can authenticate against it?). I doubt that you'll need to worry about mixed mode, however it might be worthwhile turning it on for future. What you need to do, is ensure that you have actually added the account as a logon, with the appropriate access. Did you expand the 'logins' node in management studio at the top level, add the account, then in the user mappings select your database and assign it DB owner privilege? Cheers, Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 2:36 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Hi Matthew, Thanks for your response. There is nothing in the log except a couple of old entries. Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (The item was deleted because it was either not found or the crawler was denied access to it.) I have since fixed this and gave permission to the correct account. Although just to double check I tried to login to sql database using the provide account and it stipulates the following: The following knowledgebase article will help you to resolve error message Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) during SQL logon process. http://support.microsoft.com/kb/555332 Its currently not set to mixed mode but the account is an AD account...? I can try and change it to mixed mode after business hours (as would required sql reboot) but wouldn't it say 'Access is denied' in the search log? Regards, Trent From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Tuesday, 22 July 2008 1:29 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: MOSS Search Hi Trent, I find it hard that there isn't anything being listed in the crawl logs. Can you go into 'search settings', then take a look at the 'crawl log' in there. You should be able to see the reason why it's failing (sounds like permissions.) Which account have you set up as the crawling account? Can you double check this, then make sure it does in fact have appropriate access? Cheers, Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 11:40 AM To: listserver@ozMOSS.com Subject: [OzMOSS] MOSS Search Hi, Am having a great deal of trouble trying to get the MOSS search function to work. I can get it work on my testing environment no worries but struggling on production env. Does anybody know of a good tutorial on how to turn on the search function. What I have done: * Ensured service is turned on. * Default content access account has permission to SharePoint SQL Database * Content Sources should be correct. o I have tried both internal external addresses If I tick the checkbox 'Start full crawl of this content source' it begins to crawl but the status just stays on 'Crawling Full'. Its been this way for a week! Nothing is returned in the site search. From what I can see there is nothing being returned in the logs. Could anybody point me in the right direction please? Any help would be greatly appreciated... Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: MOSS Search
Sorry guys I haven't been following this thread until now, but as soon as saw stuck on crawling it made me think of a recent problem I had with SQLSP1, maintenance plans and corrupt indexes http://www.cleverworkarounds.com/2008/07/09/office-server-search-memory-leak -and-stuck-on-crawling/ Also check the personalisation service permissions of the crawler account in the SSP. I've seen this stick because the crawler can't access the user profile store. Hope that helps Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Allday Sent: Tuesday, 22 July 2008 1:39 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: MOSS Search Yeah correct. SQL is own its own machine. Web server on own machine. AD on own machine. All on same network and domain. My test env is on one env (nice easy J). Regards, Trent --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
