none
Event 28005 in the application log RRS feed

  • Question

  • Hi,

    I have a Windows 2008 Server running Sharepoint 2010, the server is a member server in our domain with Exchange 2007 installed on a domain controller on the network.

    At the moment the sharepoint server is not been utilised as we are setting up what we need on it for a start but I have noticed that the Application log is full of 28005 errors the full error is:

    Log Name:      Application
    Source:        MSSQL$SHAREPOINT
    Date:          17/04/2013 15:18:30
    Event ID:      28005
    Task Category: Server
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      rdsqlikview.reflexdata.co.uk
    Description:
    An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MSSQL$SHAREPOINT" />
        <EventID Qualifiers="49152">28005</EventID>
        <Level>2</Level>
        <Task>2</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2013-04-17T14:18:30.000000000Z" />
        <EventRecordID>5244859</EventRecordID>
        <Channel>Application</Channel>
        <Computer>rdsqlikview.reflexdata.co.uk</Computer>
        <Security />
      </System>
      <EventData>
        <Data>15517</Data>
        <Data>1</Data>
        <Data>Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.</Data>
        <Binary>656D0000100000001700000052004400530051004C0049004B0056004900450057005C005300480041005200450050004F0049004E0054000000070000006D00610073007400650072000000</Binary>
      </EventData>
    </Event>

    I have looked at all the solutions for this but my SQL knowledge is fairly limited so I am not sure how to find most of the information that the posts are asking for.

    Can anyone help me resolve this problem please?

    Thanks for your help

    Alamb200


    • Edited by alamb200 Wednesday, April 17, 2013 3:12 PM update
    Wednesday, April 17, 2013 3:01 PM

Answers

  • Hi,

    Here is the steps to create/add new user: (Make sure that you are adding same user, which you have used to install sharepoint. In other words you need to sharepoint farm admin in SQL DB)

    http://msdn.microsoft.com/en-in/library/aa337545.aspx

    Let us know your result


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Please feel free to unmark answer if does not resolves your problem.

    • Proposed as answer by SekThang Saturday, April 20, 2013 6:16 PM
    • Marked as answer by Jack-GaoModerator Thursday, April 25, 2013 9:41 AM
    Friday, April 19, 2013 4:51 AM
    Moderator

All replies

  • Hi alamb200,

    Please find your problem database, use the following command in your databse.

     

     

    USE asd  --asd is my database name
    EXEC sp_changedbowner 'sa'

    Thanks,

    Jack


    Jack Gao
    TechNet Community Support

    Thursday, April 18, 2013 7:19 AM
    Moderator
  • Hi Jack,

    Thanks for the reply. As I said I am not very good with SQL so how do I find out which database it is that has the problem?

    Thanks and sorry,

    alamb200

    Thursday, April 18, 2013 8:44 AM
  • Hi,

    You can add your name a Db admin in SQL server and provide owner right. To do this please open SQL management studio-->connect for MSSQL$SHAREPOINT-->click on security-->right click on your name-->click properties-->click user mapping-->now click on database and give yourself DB right by checking db_owner checkbox.

    Hope it could help


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Please feel free to unmark answer if does not resolves your problem.

    Thursday, April 18, 2013 10:40 AM
    Moderator
  • I have looked at this but I do not have a user. this is what I see:

    Does that help?

    Thursday, April 18, 2013 12:21 PM
  • Hi,

    Here is the steps to create/add new user: (Make sure that you are adding same user, which you have used to install sharepoint. In other words you need to sharepoint farm admin in SQL DB)

    http://msdn.microsoft.com/en-in/library/aa337545.aspx

    Let us know your result


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Please feel free to unmark answer if does not resolves your problem.

    • Proposed as answer by SekThang Saturday, April 20, 2013 6:16 PM
    • Marked as answer by Jack-GaoModerator Thursday, April 25, 2013 9:41 AM
    Friday, April 19, 2013 4:51 AM
    Moderator