sql server error 18456, login failed for USER 'NTAUTHORITY\SYSTEM'. [SQL STATE 28000]

  • Hi Folks,

    1.sql server error 258, unable to complete login process due to delay in login response,[ SQL STATE 08001].

    2.sql server error 4060, cannot open database '--'requested by login. The failed login [SQL STATE 42000]

    3.sql server error 18456, login failed for USER 'NTAUTHORITY\SYSTEM'. [SQL STATE 28000]

    Am facing the problem from yesterday plz. help me to fix this issue am in a critical position to fix this issue.

  • I guess this link should help you to get started.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • Thanks to see your reply..

    I tried to route cause this issue and i came across several observations like

    1. Checked whether Builtin\Adminstrator account is there or not. i've seen the Builtin\Adminstrator Account in the security pane of the Database.

    2. Remote connections like TCP/IP & Named Pipes are enabled.

  • Hi all,

    Can anyone suggest me regarding this issue..

  • The link I provided was to demonstrate how to narrow down the issue.

    Did you try finding other web references for the other error codes you posted?



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply