Post reply

Login Error

  • March 9, 2007 at 1:55 am

    #172633

    Ever since I installed Windows updates last month I have been getting the following error:

    Cannot connect to SQLSERVER

    ------------------------------

    ADDITIONAL INFORMATION:

    Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

    I re-booted it and still have the same problem.  This only happens to new users added to access SQL.

    I'm running SQL2005 Enterprise Edition SP1 on 64bit Server 2003 R2.

    Is anyone able to help me.  This is getting very urgent and I hope I've just missed something stupid.

    Thanks in advance 

    Thanks,

    Kris

  • March 10, 2007 at 4:29 am

    #694226

    O.K.  After hours and hours of searching the internet, I came to the conclusion it was a Windows fault not SQL.  Any Windows accounts that were created earlier, worked fine but any new ones the error message made it sound like the server was SQL authentication only.  My conclusion was that AD was no longer updating SQL to any changes.

    I rebooted the domain controller, and everything now works.  The only error message I could find on the domain controller that seems to match up to the time period is the following:

    Internal event: Active Directory has encountered the following exception and associated parameters.

    Exception:

    e0010004

    Parameter:

    0

    Additional Data

    Error value:

    -1603

    Internal ID:

    2050344

    For more information, see Help and Support Center at

    Anyway rebooting the domain controller fixed the issue if anyone comes across this issue.

    Thanks,

    Kris

  • June 28, 2007 at 5:28 am

    #715805

    You will get this error if you have windows authentication mode set in your server and try to use sql server login to logon to the server. Change the authentication mode to mixed to use SQL logins.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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