Solved

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

Posted on 2014-10-08
8
102 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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
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
 

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

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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.

739 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