question

hellerim avatar image
hellerim asked

Valid dbowner for installing diagram support

The common problem that trying to install diagram support does not work without a valid database owner comes in a special flavour on one of my computers: Even with a newly created empty database this error shows up although the database has an owner which in my opinion should be valid. Here, SQL Server 2012 runs on 64-bit Win 8.1 (the only one in my network) in a Windows domain. Is there any idea what's going wrong?
ownershipdiagrams
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
What is the database owner and what errors are you getting?
1 Like 1 ·

1 Answer

·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered
Was the creator of the database a sysadmin? If not, change the owner to sa and then change the owner to a different login. ALTER AUTHORIZATION ON DATABASE::YourDBHere TO [sa];
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

hellerim avatar image hellerim commented ·
Hi CirqueDeSQLeil, thanks for your rapid answer. Quite interestingly, the problem was resolved by itself. I suppose that it was a very special connectivity problem. The computer was connected only via WLAN which has a completely different IP-Range without bridging to the cable-based LAN over which my domain server is connected. For some reason I plugged in a cable. Suddenly, I was able to install diagram support. Apparently, DNS and Kerberos cross IP borders, while the communication required for SQL Server in this case does not. Another explanation could be that DNS and Kerberos appear to work because of caching, but in reality there was no communication at all.
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.