Adding user to a defualt schema

This topic contains 3 replies, has 3 voices, and was last updated by Avatar Dext 4 years ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • Avatar
    5habbaranks
    Participant
    #165814

    Hi guys,

    Im having a bit of an issue with my SQL server what I am trying to do is map a user to the dbo default schema within MSSQL 2008. If I tick map and select the database then edit the default schema to dbo I get An exception occurred while executing a Transact-SQL statement or batch. User, Group or role ‘user’ already exists in the current database.

    Which is true the user does but I want to map it to that schema?

    Any ideas?

    Avatar
    Dext
    Member
    #379061

    Just to elaborate on this looking at the error 15023 is it because the database was restored from a different server?

    Avatar
    Dext
    Member
    #379062

    Fixed this, just incase anyone has an issue where by you try and add users to a dbo mapping and it says the user already exists – the chances are you have restored the DB and the user SIDS have gone a bit wonky. What I did was re create the user account and all was fine.

    Avatar
    Ossian
    Moderator
    #190936

    Well done, and thanks for posting back

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

You must be logged in to reply to this topic.