No announcement yet.

Adding user to a defualt schema

  • Filter
  • Time
  • Show
Clear All
new posts

  • Adding user to a defualt schema

    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?

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


    • #3
      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.


      • #4
        Well done, and thanks for posting back
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd

        ** Remember to give credit where credit is due and leave reputation points where appropriate **