Post reply

SQL server error : 18456 login failed for sql service account.

  • December 8, 2009 at 11:52 am

    #143438

    We have a database server that paticularly used for our sharepoint website.

    I see in the sql server current log, we have an error like this: 18456 ,everity 14, login failed for user ourdomain\spssqlsvc [cleint :,local machine]. it apppears every minite twice in the log. And it has been there for many days. We haven't experienced any obvious issues from front end.

    The account is our sql server service acount.

    Thanks

  • December 8, 2009 at 12:17 pm

    #1089416

    Well if your database server is running, that's not the issue. However you can have multiple services or users, or even applications using that account. It's possible that someone configured it elsewhere for another service and it has the wrong password.

    I would look for more details in the Event log, or set up a trace to capture where this is coming from and what application is using this login.

  • December 8, 2009 at 12:30 pm

    #1089428

    If you can provide the error state, then it would be much easier to troubleshoot. check the below link.

    http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

  • December 8, 2009 at 12:58 pm

    #1089465

    Thank you.

    Error:18456. severity:14, State:16

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

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