setting up a database with sql server 2016 express

Setting compatibility level to 90 (SQL Server 2005) before installing the diagram support objects solves this problem. The installation fails and the UI incorrectly reports that the database has no valid owner.

There is also a known issue when the UI tries to install the database support objects on databases where the compatibility level is set to 80 (SQL Server 2000). Explicitly setting the owner to a valid principal on the server solves the problem. The SID (a large number) doesn't match any existing login on the new server, so the owner name remains whatever it was on the old server, but it is marked invalid. The 'no valid owner' issue usually comes up when databases are owned by SQL-authentication logins and are upgraded, detached/attached to another server, or restored from backup to another server. When the database does not have a valid owner, the database dialog displays the owner as the logged in user. To save you the click, here is the answer from a person that I believe is an MSFT employee: If either of these is the case, there is a thread that address it here. I do not know how to solve it and create a valid user, my database name is 'tarita' and sql sever name is 'FENG', hope somebody can teach me how to solve the problem during setting up the databae diagram, thanks for your help!!!ĭid you install your SQLExpress over an MSDE installation or is your database restored from a backup of a SQL 2000 Database? Is your database in SQL 2000 compatibility level? Which one i should choose? what is useful for? Then i click the Browse, it came out 5 objects: Why my database do not have a valid owner and where is the 'ALTER AUTHORIZATION statement? Recording to the message, i go to my database 'Properties' and click 'files', then i saw the 'Owner' item, i click the browse, i read the examples, but i do not understand it: To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.' 'Database diagram support objects cannot be installed because this database does not have a valid owner. After i created my database, i want to set up the database diagram, when i click 'new database diagram', one message came out

Setting up a database with sql server 2016 express