While Creating an User to a Database am getting an error

  • Dear All,

    Am Using 2008R2 Server,Windows 7 OS.

    while creating an user am getting an user

    pleas suggest me some resolutions

    PFA

    Regards

    Jagadeesh...

    Regards
    Chowdary...

  • The login Amtpl is already mapped to a different database user. Use the following to identify the logins current database user account

    use [yourdb]

    selectd.name as DBUsername

    , s.name as Loginname

    from sys.database_principals d

    inner join sys.server_principals s

    on d.sid = s.sid

    where s.name = 'amtpl'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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