Windows

SQL 2008 greške pri instalaciji

velda February 8, 2018

Unable to start T-SQL Debugging. Could not connect to computer (“*”).
Pošto moja VM nije u domenu (sem sopstvenom), ovo se rešava tako što SQL SMSS pokrećem kao 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.
To mi se javilo čim sam uradila “restore” neke bazice.
Pokrenem SQL SMSS kao Administrator, logujem se kao “sa” (DB admin kreiran pri instalaciji MS SQL 2008 servera), i uradim “New Query” :
ALTER AUTHORIZATION ON DATABASE::ime-moje-bazice TO sa;
I to je izgleda rešilo problem.
Dobar link po ovom pitanju.