Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 111
  • Last Modified:

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

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
lapucca
Asked:
lapucca
2 Solutions
 
Brian CroweDatabase AdministratorCommented:
Nothing attached...what is the message?
0
 
Scott PletcherSenior DBACommented:
Maybe the q subject is supposed to be the error message (?), but it's not complete enough.
0
 
lapuccaAuthor Commented:
My apology, here is the attachment of the error message.
sqlerr.jpg
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
Anthony PerkinsCommented:
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
 
lapuccaAuthor Commented:
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
 
Scott PletcherSenior DBACommented:
Try:
...
WHERE name = 'AdventureWorks2012'
0
 
lapuccaAuthor Commented:
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
 
lapuccaAuthor Commented:
Never mind.  It stops giving the error message when I click on the DB Diagram.  Don't know why.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now