Lỗi không tạo được Diagrams trong SQL Server

Hôm nay, trong lúc mình thi môn Công Nghệ Phần Mềm mới thì gặp phải lỗi này. :

[notification type=”alert-warning” close=”false” ]TITLE: Microsoft SQL Server Management Studio —————————— 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. —————————— BUTTONS: OK ——————————[/notification]

Nó đã ngốn của mình rất nhiều thời gian, khiến mình làm bài không được. Mình nghĩ là mình đã rớt môn này rồi :(.

Sau đây, mình xin chia sẻ cách khắc phục cho những bạn khi làm việc với SQL Server bị lỗi đáng ghét này 🙁

Các bạn làm theo các bước như hình nhé :

Lỗi không tạo được sơ đồ (Diagrams) khi làm việc với Database trong SQL Server

Nguyên nhân lỗi gây ra là do cơ sở dữ liệu chưa được chọn người dùng có quyền để thao tác. Để thực hiện được tạo sơ đồ liên kết ta làm như sau.

Còn nếu mà không sử dụng được SQL server thì bạn có thể tham khảo thêm công cụ


cũng rất mạnh. Các bạn có thể click vào tên phần mềm để download và lên google kiếm TUT về đọc nhé.

Chúc các bạn thành công.

Share on:

Chào bạn, tại blog này mình kể về hành trình kiếm tiền online của mình. Những kinh nghiệm, những bài học, đút kết hay đôi khi chỉ là khoe thành tích để tạo cảm hứng cho người đọc. Vì 1 mục tiêu độc lập, tự do, hạnh phúc. Mình yêu thích sự chia sẻ. Chúc bạn nhận được giá trị từ blog của mình.

31 thoughts on “Lỗi không tạo được Diagrams trong SQL Server”

  1. Khi có những nhược điểm không như mong muốn trên khuôn mặt hay cơ thể,
    phẫu thuật thẩm mỹ trở thành một
    trong những cách thức được nhiều người lựa chọn để thay đổi những khiếm khuyết đó.

  2. Hellⲟ thеre! Тһіs post coսld not be wrіtten any bеtter!

    Reading tһrough thіs post reminds me of my previⲟus room mate!
    Ꮋe alwaүs kеpt chatting ɑbout this. Ӏ ѡill forward tһіs post tߋ him.
    Pretty sure hе will havе a good rеad. Mаny thanks foг sharing!

  3. If they do not, the federal government isn’t getting the
    revenue, therefore, they need anyone to collect that cash for the children, thus, doing their
    job for them. Concrete driveways will also be good insulators, so heat energy is
    a bit more easily stored into concrete. However,
    good roofing contractors will be able to work even during wet weather conditions.

  4. Oh my goodness! Awesome article dude! Thanks,
    However I am going through problems with your RSS.
    I don’t understand the reason why I can’t join it. Is there anybody having identical RSS problems?
    Anyone that knows the solution can you kindly respond? Thanx!!

  5. Magnificent items from you, man. I have be aware your stuff prior
    to and you’re simply extremely excellent. I really like what you’ve got here, really like what you’re saying and
    the way by which you assert it. You are making it enjoyable and you continue to take care of to stay it sensible.
    I cant wait to read much more from you. That is actually a wonderful
    web site.

  6. I’m not that much of a internet reader to be honest but your blogs really nice, keep it up!
    I’ll go ahead and bookmark your site to come back down the road.

  7. Does your blog have a contact page? I’m having trouble locating it but, I’d
    like to send you an e-mail. I’ve got some recommendations for your blog you might be interested in hearing.

    Either way, great website and I look forward
    to seeing it develop over time.

  8. It’s a pity you don’t have a donate button! I’d certainly donate to this outstanding blog!
    I guess for now i’ll settle for bookmarking and adding
    your RSS feed to my Google account. I look forward to fresh updates and
    will talk about this blog with my Facebook group. Talk soon!

  9. Hmm is anyone else having problems with the pictures
    on this blog loading? I’m trying to determine if its a problem on my
    end or if it’s the blog. Any feed-back would be greatly appreciated.

  10. I do not even know how I ended up here, but I thought this post
    was great. I do not know who you are but definitely you’re going
    to a famous blogger if you aren’t already 😉 Cheers!

  11. * Inspect the facility of water control – Check out the place that the drainage pipes and gutters carry the excess water.
    So now imagine that simply how much information’s can be found there to grab.
    It’s imperative that you keep in mind that not all
    zoning is a useful one zoning in terms of urban agriculture.

  12. Pingback: URL
  13. Wonderful goods from you, man. І’ve understand your stuff ρrevious t᧐ and yoս’re jᥙst
    too excellent. I reaⅼly liҝe what you’ve acquired heгe, certainly ⅼike what ʏ᧐u’re sɑying and the way in ѡhich you saү it.

    You mаke it enjoyable and you ѕtill care for tߋ keep it wise.
    I сant wait t᧐ read fаr more fгom yoᥙ. This
    is aϲtually ɑ terrific site.

  14. A multi million dollar project of a five star hotel inside the middle of the desert won’t ever prove to be profitable which means you should
    research about the potential in the region as
    well. If you are a new couple trying to find a family, build
    rooms based on the quantity of children you are planning
    to have. Selling a home and getting something more
    affordable nowadays can be quite a challenge,
    as sellers won’t likely get as much for their
    home because they would have prior to housing market bust.

  15. The primary good thing about Loveland Co real-estate listings online
    is allowing users to develop a sound insight concerning the current houses available within the
    market. The township is put in the prime location of city
    wherein many and most of the significant landmarks of city are placed with a close proximity.

    The 80% back loan that has been a set rate of sometimes as little
    as 5% therefore the front loan.


Leave a Comment