I am using SQL Server Express 2008. I just created a new database called "TC3". I am trying to map my login to this database, but getting the error "Cannot alter the user 'dbo'.
I go to the security >> logins node and double click my user login:
Under the Users mapped to this login I have the TC3 database checked with the user 'dbo' and default schema 'dbo'. I try to change the user to [MachineName]\[Username] and get the above error message.
Why can't I map my user login to this database?
These are the same steps I used with SQL Server Express 2005 and never had any problem. I'm not sure what is going on here.
Thanks for any help.