Post reply

Login failed for user

  • May 12, 2010 at 4:08 am

    #144696

    Hi All

    I am facing one problem as follows

    I see in sql server error log , it's showing

    Login failed for user 'domainname\loginname'. [CLIENT: xx.x.xx.xxx] & Error: 18456, Severity: 14, State: 16.

    I started sql profiler and found that this is coming from windows sharepoint service

    but not able to found out the exact problem & solution

    this user does not have any rights on master database & I also checked it assigning rights on master db but no help.

    Could anybody help me regarding this issue

    Thanks

    Ghanshyam

  • May 12, 2010 at 6:40 am

    #1166148

    For error 18456, the value of "State" describes the reasons why the login failed. A state of 16 indicates that the default database for the login is not available.

    SQL = Scarcely Qualifies as a Language

  • May 13, 2010 at 1:35 am

    #1166678

    Hi

    Even I have assigned master DB as DB_owner for this login also , Still Same error

    Thanks

    Ghanshyam

  • May 14, 2010 at 3:34 am

    #1167393

    And is "master" the default database for this user according to the properties in Security->Logins?

  • May 14, 2010 at 8:42 am

    #1167587

    yes , master is the default db for this user

    Thanks

    ghanshyam

  • May 22, 2011 at 11:58 pm

    #1328296

    hi, the error says the the current user you are working is not granted with the proper login credentials, open the management studio, with the admin user, i mean the user name with which sql server is installed or with any admin user,

    in the server objects

    go to security > login-> add the user name and specify the server roles of the user

  • May 23, 2011 at 12:00 am

    #1328297

    Carl Federl (5/12/2010)

    For error 18456, the value of "State" describes the reasons why the login failed. A state of 16 indicates that the default database for the login is not available.

    severiy 14 " Indicates security-related errors, such as permission denied."

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

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