?
Solved

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

Posted on 2014-10-08
8
Medium Priority
?
105 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 34

Expert Comment

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

Expert Comment

by:Scott Pletcher
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
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 1000 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
 

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:Scott Pletcher
Scott Pletcher earned 1000 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

752 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