Post reply

Create failed for user 'tb'

  • October 9, 2014 at 12:11 am

    #311655

    Hi gail please respond wiht solutions its killing my time from morinig nealry from 3 hours

    Create Failed for user 'tb'

    and its getting error user,group or role 'tb' already exists in the current database error 15023

    Thanks
    Naga.Rohitkumar

  • October 9, 2014 at 12:47 am

    #1751161

    Does the user tb already exist in the database?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 9, 2014 at 8:51 pm

    #1751483

    yes and this login issues is coming frequently as per the conversation i had with the application team members

    HI ,

    valuable inputs may be highly appreciated

    1. what i have done to solve this is to make sure any Backup/Restore happened Earlier from production to staging

    Yes it happened

    2. Then i have identified that Orphan logins are not mapped after the Backup/Restoration

    I have Mapped those orphan login."tb" and the issue was solved

    3. The isuses like error number 18456 and 4064

    by this error msgs ihave fixed the orphan logins

    what is would like to know the root cause by which this incident may not come recursively

    Thanks

    Naga.RohitKumar

    Thanks
    Naga.Rohitkumar

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

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