Solved

Can't open the "Database Diagrams" in SQL 2012 ssms

Posted on 2014-10-08
8
85 Views
Last Modified: 2014-10-13
Hi,
I followed the instruction and put my self and SA as owner of this database in the File property.  I refreshed, I disconnected, re-connected to DB but I still get the message attached.  I check and rechecked and I am the owner in the file property.  The SQL is local on my PC and is setup for Windows authentication only.

How to fix this?  Thank you.
0
Comment
Question by:lapucca
8 Comments
 
LVL 34

Expert Comment

by:Brian Crowe
ID: 40369534
Nothing attached...what is the message?
0
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 40369536
Maybe the q subject is supposed to be the error message (?), but it's not complete enough.
0
 

Author Comment

by:lapucca
ID: 40371121
My apology, here is the attachment of the error message.
sqlerr.jpg
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 40372064
Are you a member of the db_owner database role ?

Do you get the expected database owner name when you do this:
SELECT  name, SUSER_SNAME(owner_sid)
FROM sys.databases
WHERE name = 'yourdatabasename'
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:lapucca
ID: 40377474
I ran this and nothing is selected
SELECT  name, SUSER_SNAME(owner_sid)
FROM sys.databases
WHERE name = '[AdventureWorks2012]'

I guess just setting myself in as owner of this database in the File property isn't enough.  I look at under Security expanding that with server Roles still doesn't show db_owner database role.  Where can I find that to add myself?  Thank you.
0
 
LVL 69

Assisted Solution

by:ScottPletcher
ScottPletcher earned 250 total points
ID: 40377495
Try:
...
WHERE name = 'AdventureWorks2012'
0
 

Author Comment

by:lapucca
ID: 40377573
Ah!  That worked.  It does select and return my name.   Then why I kept getting the error message when I click on the Database Diagram?  Thankl you
0
 

Author Comment

by:lapucca
ID: 40377574
Never mind.  It stops giving the error message when I click on the DB Diagram.  Don't know why.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now