locked
SharePoint Errors 3760, 18456 and 2436 RRS feed

  • Question

  • Hello,

    In the appliction event log, I see errors 3760, 18456 and 2436 that happen at the same time. For the error 3760, I see this message:

    Cannot open database "WSS_Content_81" requested by the login. The login failed. Login failed for user 'PBTF\SvcMOSS'.

    So, I checked a few things:

    The SharePoint site is using a content database named STS_Chinook_1. This is from the Manage Content Databases page in Sharepoint 3.0 Central Admin.
    In SQL Server Management Studio, the STS_Chinook_1 database is filled with tables and data.
    In SQL Server Management Studio, I also see WSS_Content_81 as a database, but can't open the properties (an error is shown) and no objects are shwon underneath the database name. 

    This is WSS 3.0 on a Windows Server 2003 server. The site is up and running, but SharePoint is trying to connect and use to this WSS_Content_81 (bad) database. What can I do disable/remove this bad database?


    Event Type: Failure Audit
    Event Source: MSSQL$MICROSOFT##SSEE
    Event Category: (4)
    Event ID: 18456
    Date:  5/13/2011
    Time:  2:35:53 PM
    User:  PBTF\SvcMOSS
    Computer: CHINOOK
    Description:
    The description for Event ID ( 18456 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: PBTF\SvcMOSS,  [CLIENT: <named pipe>].


    Event Type: Warning
    Event Source: Windows SharePoint Services 3 Search
    Event Category: Gatherer
    Event ID: 2436
    Date:  5/13/2011
    Time:  2:30:20 PM
    User:  N/A
    Computer: CHINOOK
    Description:
    The start address <sts3://chinook:81/contentdbid={104a483a-6a73-4d6b-8a74-702fbc92a825}> cannot be crawled.

    Context: Application 'Search index file on the search server', Catalog 'Search'

    Details:
     Error in the Site Data Web Service.   (0x80042616)

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Can you help?

    thanks

     

    Friday, May 13, 2011 10:04 PM

Answers

  • First, Can you make sure by navigation to central administration and determine whether the database is being used by any of the web applications?

    If you cannot find the web application that is accessing this particular content database, the only reason the content database might exist is because the web application was deleted without actually deleting the content database. 

    You can delete the content database using Sql Server management studio. 

    As another alternative, which I prefer, would be to

     a- Create New web application from central administartion.
       b- delete content database of your new web application.
       c- use stsadm command to add your old content database to your web application as the following:-
           stsadm -o addcontentdb -url http://portal -databasename youroldDB -databaseserver yourDBserver.

    This way, you would atleast know the data associated with the content database. 

    Regarding the error, "Cannot open database "WSS_Content_81" requested by the login. The login failed. Login failed for user 'PBTF\SvcMOSS", you might want to assign 'PBTF\SvcMOSS' the necessary permissions to that particular user to access the database. The search might be trying to crawl the database which is resulting in this error. Hope this helps. 


    V
    • Marked as answer by Doug Fir Wednesday, May 18, 2011 9:17 PM
    Sunday, May 15, 2011 2:51 PM
  • Hi Doug Fir,

     

    From the description of this issue, it seems that it is related with your SQL server.

     

    For Event 3760, please make sure you are using the correct account. For detailed information about this, you can go through this article:

    http://technet.microsoft.com/zh-cn/library/cc561036(office.12).aspx,

    and this thread:

    http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/307ca64c-8944-4756-9dbe-8ae65efb1925.

     

    Event 18456 is the most unanimous when it comes to SQL server user rights. And moreover this error 18456 is a generic message and the state described with this error in sp_readerrorlog is important as that can be handy to track down the exact reason. You can go through these two articles, you will get a complete description and solution of the problems:

    http://www.eraofdata.com/blog/sql-18456-login-failures/;

    http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/.

     

    Event 2436 occurs if text (.txt) files are blocked on the Blocked File Types page in SharePoint Server 2007. The gatherer is unable to access the Robots.txt file when it starts to crawl the specified URL. Please look into this KB article to get detailed information and solution of this problem:

    http://support.microsoft.com/kb/952172.

     

    Thanks & Regards,

    Peng Lei

    • Marked as answer by Doug Fir Wednesday, May 18, 2011 9:17 PM
    Monday, May 16, 2011 3:31 AM

All replies

  • First, Can you make sure by navigation to central administration and determine whether the database is being used by any of the web applications?

    If you cannot find the web application that is accessing this particular content database, the only reason the content database might exist is because the web application was deleted without actually deleting the content database. 

    You can delete the content database using Sql Server management studio. 

    As another alternative, which I prefer, would be to

     a- Create New web application from central administartion.
       b- delete content database of your new web application.
       c- use stsadm command to add your old content database to your web application as the following:-
           stsadm -o addcontentdb -url http://portal -databasename youroldDB -databaseserver yourDBserver.

    This way, you would atleast know the data associated with the content database. 

    Regarding the error, "Cannot open database "WSS_Content_81" requested by the login. The login failed. Login failed for user 'PBTF\SvcMOSS", you might want to assign 'PBTF\SvcMOSS' the necessary permissions to that particular user to access the database. The search might be trying to crawl the database which is resulting in this error. Hope this helps. 


    V
    • Marked as answer by Doug Fir Wednesday, May 18, 2011 9:17 PM
    Sunday, May 15, 2011 2:51 PM
  • Hi Doug Fir,

     

    From the description of this issue, it seems that it is related with your SQL server.

     

    For Event 3760, please make sure you are using the correct account. For detailed information about this, you can go through this article:

    http://technet.microsoft.com/zh-cn/library/cc561036(office.12).aspx,

    and this thread:

    http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/307ca64c-8944-4756-9dbe-8ae65efb1925.

     

    Event 18456 is the most unanimous when it comes to SQL server user rights. And moreover this error 18456 is a generic message and the state described with this error in sp_readerrorlog is important as that can be handy to track down the exact reason. You can go through these two articles, you will get a complete description and solution of the problems:

    http://www.eraofdata.com/blog/sql-18456-login-failures/;

    http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/.

     

    Event 2436 occurs if text (.txt) files are blocked on the Blocked File Types page in SharePoint Server 2007. The gatherer is unable to access the Robots.txt file when it starts to crawl the specified URL. Please look into this KB article to get detailed information and solution of this problem:

    http://support.microsoft.com/kb/952172.

     

    Thanks & Regards,

    Peng Lei

    • Marked as answer by Doug Fir Wednesday, May 18, 2011 9:17 PM
    Monday, May 16, 2011 3:31 AM