none
Login failed for user. Error 18456

    Question

  • Hi All,

    Good day. I am just new in SQL 2012 r2 and we are trying to provision one SQL VM but we are getting an error a"Login failed for user. "Error 18456" when trying to login to the Database Engine for the 1st time via SQL Management Studio. We carefully follow the steps outline in the link below but no luck.

    http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-provision-sql-server/

    These are the logs"

    2015-05-06 12:44:49.57 Logon       Error: 18456, Severity: 14, State: 5.
    2015-05-06 12:44:49.57 Logon       Login failed for user 'SD\Admin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
    2015-05-06 12:49:05.23 Logon       Error: 18456, Severity: 14, State: 5.
    2015-05-06 12:49:05.23 Logon       Login failed for user 'SD\Admin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
    2015-05-06 12:57:58.16 Logon       Error: 18456, Severity: 14, State: 5.
    2015-05-06 12:57:58.16 Logon       Login failed for user 'SD\Admin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
    2015-05-06 12:58:00.90 Logon       Error: 18456, Severity: 14, State: 5.
    2015-05-06 12:58:00.90 Logon       Login failed for user 'SD\SAdmin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
    2015-05-06 12:58:04.23 Logon       Error: 18456, Severity: 14, State: 5.
    2015-05-06 12:58:04.23 Logon       Login failed for user 'SD\SPAdmin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

    Steps Taken:

    Allow 1433 firewall, use login as servername\default instance name, servername\local admin

    Did we miss any steps?

    Any advise will be much appreciated.

    Thanks,

    Glenn Jose



    Wednesday, May 06, 2015 1:30 PM

Answers

All replies