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.

Từ Khoá được tìm kiếm:

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 mｙ previⲟus room mate!
    Ꮋe alwaүs kеpt chatting ɑbout this. Ӏ ѡill forward tһіs post tߋ him.
    Pretty surｅ 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?

  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.
    web site.



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

    I guess for now i’ll settle for bookmarking and adding

  9. Hmm is anyone else having problems with the pictures

    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’rｅ 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᧐ ｒead fаr more fгom ｙoᥙ. 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

Get it Now!