asked on SSMS Error trying to create a table relationship diagram in SSMS
Hi
I tried to set up a database diagram in SSMS for the first time and got the following error. I'm not sure what to do
Microsoft SQL Server Management Studio
A member of the db_owner role must use the database diagramming functionality in order to setup the required database diagramming objects on the SQL Server."
Microsoft SQL Server
Last Comment
Qlemo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi. I set the database up on GoDaddy. I would assume that I am the owner
You should think so. The creator of a database is automatically DBO ... But just check that the DB is indeed owned by you (in the DB properties). And if not, assign the role to your user for that database.