Cannot connect to Database engine in server as administrator RRS feed

  • Question

  • Hello  all

    I am loging in ABCtest server as administrator. I can connect to reporting services and analysis but I cannot connect to Database Engine(using window Authincation)

    the message is displaying :

    Login faild for user 'ABCTEST\administrator' ( Microsoft sql server Error:18456).


    I can log to server ABCtest using one user created as domain ZWX and it can connect to Database Engine.. I don't understand why administrator can't connect to Database Engine.

    So could anyone help me in this issue :

    Note connection using:

    using sql server 2008 r2

    server type: Database Engine

    server name: ABCtest\hayalims

    authinication: Window Authinication


    Tuesday, July 10, 2012 8:06 AM


All replies