Post reply

Unable to login with windows authentication

  • March 26, 2012 at 10:39 pm

    #258252

    Hi

    I have installed sql server 2005 with windows authentication. But later while trying to login, it is throwing "login failed for user" 18452 error. I am a domain user.

    Hence I have tried to go for mixed mode but since there is no password set, it is also throwing the same error.

    I am a domain user but not logged in as an administrator though I have the full power of admin.

    Now I am not able to login as windows or mixed authentication.

    Please help.

    Regards,

    Arup

  • March 27, 2012 at 10:03 pm

    #1465451

    Hi,

    Any solution for my problem?

    Regards,

    Arup

  • March 27, 2012 at 10:58 pm

    #1465459

    Look specifically at the full error message:

    select * from sys.messages where message_id = '18452' and language_id = 1033

    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.%.*ls

    It indicates that SQL Server can't trust the domain that the windows user belongs to. Are you an administrator on the local machine where the SQL Server instance is running?

    Also, for SQL Server authentication, if the password is not set, it would be blank (unless of course, mixed mode authentication was not chosen during install time).

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • March 27, 2012 at 11:06 pm

    #1465460

    Hi Nakul,

    Thanks for your response.

    Problem is I am not able to open any editor even to run this error message. I ahve not the administrator of the machine,but I have full administrative control against my user id.

    Regards,

    Arup

  • March 29, 2012 at 3:06 am

    #1466239

    The error your getting normally only occurs if your trying to connect using SQL authentication when it is not enabled.

    Are you trying to connect to a named or the default instance?

    If there is more than one instance make sure that the SQL Browser Service is running

    Are all your sql services started correctly, any errors in your system logs?

  • March 29, 2012 at 6:08 am

    #1466298

    Hi,

    I am sorry that I hv not informed you...this issue has been resolved. I have reinstalled SQL server with mixed authentication and now it is working fine. Previously it seemed to be problem installation. I have not selected any domain user name and trying to use the windows authentication.

    Thanks a lot to all.

    Regards,

    Arup

Viewing 6 posts - 1 through 5 (of 5 total)

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