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.com<http://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.com<http://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 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