locked
Login failed for user 'ServerName\User' RRS feed

  • Question

  • When I Insert Data from SSIS to CRM 4.0 using Web Services I got This Error

    Login failed for user 'ServerName\User'

    The Following Error i Seen in Event Viewer

    Event ID 2803: "SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations."

    Event ID 18456: Login failed for user 'ServerName\User'. [CLIENT: IP(00.00.00.000]

    Please Help? Can anybody Tell Me Why It Giving Me Error Like This??

    Thanks in Advance

    Thursday, May 12, 2011 2:51 PM

Answers

  • Or it could be as I see your database set to AutoClose as per this article:

    http://forums.asp.net/t/1501801.aspx/1


    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by RamJaddu Thursday, May 12, 2011 3:22 PM
    • Marked as answer by Tony Chain Saturday, May 21, 2011 8:03 AM
    Thursday, May 12, 2011 3:15 PM

All replies

  • Clearly an infrastructure issue e.g. remote access, user rights.

    It is happening while you are in development stage? Or after you deployed your package to a server?


    Arthur My Blog
    By: TwitterButtons.com
    Thursday, May 12, 2011 3:03 PM
  • Thanks for Quick Reply

    but SSIS Package was Working for around 10 hours after some time it gave me this error so What is Issue?Why It is Giving me this type of error While Package Was Running ???

    Thursday, May 12, 2011 3:06 PM
  • Probably that was an intermittent (or still) network blip.

    Arthur My Blog
    By: TwitterButtons.com
    Thursday, May 12, 2011 3:13 PM
  • Or it could be as I see your database set to AutoClose as per this article:

    http://forums.asp.net/t/1501801.aspx/1


    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by RamJaddu Thursday, May 12, 2011 3:22 PM
    • Marked as answer by Tony Chain Saturday, May 21, 2011 8:03 AM
    Thursday, May 12, 2011 3:15 PM