Solved

I am using server management studio and the visual tool to see the layout but I get the error

Posted on 2012-12-22
7
285 Views
Last Modified: 2013-01-15
I am using server management studio and the visual tool to see the layout but I get the error
database-diagram.jpg
0
Comment
Question by:goodk
7 Comments
 

Author Comment

by:goodk
ID: 38716353
I am using Godaddy.com sql server
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 125 total points
ID: 38716373
They will not give you access to the actual server to set that up.
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 38717652
The error message says it all:  You need to belong to the db_owner database role in order to setup using Database Diagrams.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 125 total points
ID: 38722745
You should be the owner of database to proceed. otherwise will not.
0
 

Author Comment

by:goodk
ID: 38722774
Is there any one using GoDaddy.com
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 38725772
PatelAlpesh,

You should be the owner of database to proceed. otherwise will not.
No, that is simply not true.  Once again:
You need to belong to the db_owner database role in order to setup using Database Diagrams.
0
 

Author Closing Comment

by:goodk
ID: 38781266
thanks;

the answer i got from godaddy.com that it will not work on the shared database
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 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