Login failed for user '(null)'. Reason: Not...

  • Your help is needed...

    The problem I am having is strange or I missed something:

    .NET framework and ASP.NET app is on box A, SQL server is on box B, both in the same domain. App uses impersonation, so windows user account should be used to access database. App is not anonymous, login for current windows user is set up in SQL server. If I login as administrator to box A, pages are still using data from B and working. If I take any other box (say

    C), copy the application to it, login to it and browse the pages, again it is working even it is using data from B.

    BUT IF I access app pages from any other client, I get the same error message (error 18452 - Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection) and after hours and hours I can not keep it running...

    What do I need to setup the scenario with different application/database server?

    Can somebody point me to solve this problem? Could be that the account under which is SQL server run is having insuficient permissions (when run as LocalSystem - it works)?

    Thanks in forward, Jan

  • There is some information available in MSDN-KB on this error.

    http://support.microsoft.com/default.aspx?scid=KB;EN-US;q307002&

    hope this helps.

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

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