Post reply

Error Message on the application server

  • February 6, 2015 at 7:49 pm

    #301003

    This is how the error message on the application server looks like, but the sql server error log doesn't have anything:

    <shortMessage>Fail to insert Adventureworks.inc.humanresourceslog into database SqlException: Login failed for user 'xxx'. </shortMessage>

    <shortMessage>Fail to insert Adventureworks.inc.humanresourceslog into database SqlException: Login failed for user 'xxx'. </shortMessage>

    <shortMessage>Fail to insert Adventureworks.inc.humanresourceslog into database SqlException: Login failed for user 'xxx'. </shortMessage>

    Can someone help me with this?

  • February 7, 2015 at 2:09 am

    #1776202

    Srl832 (2/6/2015)

    This is how the error message on the application server looks like, but the sql server error log doesn't have anything:

    <shortMessage>Fail to insert Adventureworks.inc.humanresourceslog into database SqlException: Login failed for user 'xxx'. </shortMessage>

    <shortMessage>Fail to insert Adventureworks.inc.humanresourceslog into database SqlException: Login failed for user 'xxx'. </shortMessage>

    <shortMessage>Fail to insert Adventureworks.inc.humanresourceslog into database SqlException: Login failed for user 'xxx'. </shortMessage>

    Can someone help me with this?

    Quick thought, you'll probably will find an Information entry for the failed login in the Windows Application log where the Source will be the SQL Server instance name with a $ notation (MSSQL$[instance name]).

    😎

    For the error, check the credentials used, authentication mode etc.

Viewing 2 posts - 1 through 2 (of 2 total)

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