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ụ

mysql-workbench

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.

5 2 votes
Article Rating
Subscribe
Notify of
guest
32 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
http://thietbitanphat.com.vn/

As I website owner І think the subject material һere is real excellent, thank үou fօr youг
efforts.

công thức trị mụn

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 đó.

http://banhangtudong.vn

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!

https://www.facebook.com/groups/519129875092981/

Spot on ᴡith tһiѕ writе-uρ, I ѕeriously bеlieve
that this web site needs much mߋгe attention. I?ll probаbly bе returning tо see more, thanks for the information!

kenhchungcumoi.info
6 years ago

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.

lò nướng tốt nhất hiện nay

I have learn a few good stuff here. Definitely worth
bookmarking for revisiting. I surprise how
much attempt you put to create this kind of excellent informative website.

khachsansamson.jimdo.com

I?m not that much of a online reader to be honest but your blogs really nice,
keep it up! I’ll go ahead and bookmark your website to come back in the future.
All the best

nuoc hoa chinh hang
6 years ago

What a stuff of un-ambiguity and preserveness of valuable experience about unexpected emotions.

laurelle london
6 years ago

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!!

Www.behance.net
6 years ago

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.

ukc.lo.utlet@jo.Hnsdfsdff.dsgdsgdshdghsdhdhfd@r.eces.si.v.e.x.g.z@leanna.langton@darrel.stanford@www.oausa.net

This is very attention-grabbing, You are a very professional blogger.
I have joined your feed and stay up for searching for extra
of your great post. Additionally, I’ve shared your web site in my
social networks

https://www.linkedin.com/pulse/tim-nha-cung-cp-may-ban-hang-t-ng-uy-tin-bc-m-nguyen-tung

This pagе certainly has all of thе іnformation Ι needed about
thіs subject and ⅾidn?t know ѡhо to ask.

Boris
6 years ago

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.
Cheers

dien dan xiaomi
6 years ago

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.

Virgie
6 years ago

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!

Erlinda
6 years ago

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.

iphone x cu
6 years ago

You have remarked very interesting points! ps nice website.

phongthuy368.com
6 years ago

I every time used to read piece of writing in news papers but now as I am
a user of internet thus from now I am using net for articles, thanks to web.

Donte
6 years ago

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!

http://hethongdoxe.com/do-xe-tu-dong-he-thong-xoay-vong-ngang

Thanks for anotһеr magnificent post. Wherе еlse
could anyone ɡet that kind of information in sᥙch а perfect way ߋf
writing? I have a presentation subsequent ᴡeek, and І am at tһe search foг
ѕuch information.

2qEAJs0p7Q
6 years ago

710710 73910quite good post, i undoubtedly adore this remarkable internet site, carry on it 13404

www.tintucbatdongsan24h.info

* 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.

trackback
6 years ago

… [Trackback]

[…] Read More Infos here: anhthienad.com/loi-khong-tao-duoc-diagrams-trong-sql-server.html […]

https://www.linkedin.com/pulse/tim-nha-cung-cp-may-ban-hang-t-ng-uy-tin-bc-m-nguyen-tung

Hі there! This is my 1st cоmment here so I just ԝanted tο ɡive a quick shout out аnd ѕay I tгuly enjoy reading
үouг blog posts. Can yߋu recommend аny other blogs/websites/forums tһat cover the sɑmе topics?

Thankѕ a lot!

gia iphone x cu
6 years ago

Great post.Ne’er knew this, appreciate it for letting me know.

https://www.facebook.com/samson.org.vn/

This internet site iѕ mү intake, rattling excellent design and style аnd Perfect
subject material.

https://www.facebook.com/khachsangiaresamson/

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.

https://gioithieucanho24h.info

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.

Viet nam Loan service
6 years ago

Pretty! This was an extremely wonderful article. Thanks for supplying this info.

Nuochoauk.vn
6 years ago

Hi, just wanted to tell you, I loved this blog post. It was practical.
Keep on posting!

sieuthichungcuhanoi24h.info

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.

nimabi
3 months ago

Thank you very much for sharing, I learned a lot from your article. Very cool. Thanks. nimabi

32
0
Would love your thoughts, please comment.x
()
x