SQL 2008 installation errors

Unable to start T-SQL Debugging. Could not connect to computer (“*”).
Since my VM is not in a AD, this is solved by starting SQL SMSS as administrator 🙂

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.
This is a message I got after some DB restoration.
I start SQL SMSS as Administrator, log as “sa” (DB admin account created during installation of MS SQL 2008 server), and doa “New Query” :
ALTER AUTHORIZATION ON DATABASE::my-DB-name TO sa;
And that apparently solved the problem.
Good link.

This entry was posted in WIN and tagged , , . Bookmark the permalink.

Comments are closed.