Archive for April 2016

Database diagram support objects cannot be installed because this database does not have a valid owner

Error:
Database diagram support objects cannot be installed because this database does not have a valid owner. 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.

Solution:
-- Replace YourDatabaseName
ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO [sa]
GO
  • Select your database >> Right Click >> Select Properties
  • Select FILE in left side of page
  • In the OWNER box, select button which has three dots (…) in it
  • Now select user ‘sa’ or NT AUTHORITY\SYSTEM and click OK.


Posted in | Leave a comment

How to add a program to startup Windows Server 2012

Open run command (Winkey+R)->

type shell:Startup

This will open a window in the otherwise hidden AppData path for the Startmenu/Programs/Startup -> Add a shortcut to the executable for the program you want to start.

This will of course only apply to the logon account that you're using at the time.

For all users type shell:Common Startup

Leave a comment