Database diagram support objects cannot be installed...
-
quinta-feira, 24 de maio de 2007 07:37
I can't make a diagram on our server(Win2003 x64,SQL 2005 Enterprise x64 sp2 3054).
I have tried to login as an admin and create a new db, but get the same message -
'Database diagram support objects cannot be installed because this database does not have a valid owner. To..'
Also tried to make a diagram from the ReportServer db.
Any suggestions?
Todas as Respostas
-
sexta-feira, 25 de maio de 2007 17:50
Two things to check.
1. please make sure that db has a owner (as the error suggests).
2. please check your compatibility level.
- Sugerido como Resposta Rob Buckles terça-feira, 23 de outubro de 2012 12:33
-
sexta-feira, 25 de maio de 2007 18:33
Thanks Meher for your reply.
1. Both of the databases I tried has a owner.
2. I'm pretty sure the compatibility level is 90 (SQL 2005) since one is created during installation(ReportServer) and the other is created as a new db in SQL Management Studio. (To be sure I will check next week)
Any other suggestions?
-
sexta-feira, 25 de maio de 2007 21:22
Are you still getting the error message?. As you have mentioned check the compatibility level once again and if you are still getting the message we can look a bit further.
-
segunda-feira, 28 de maio de 2007 07:05
The compatibility level is 90(SQL Server 2005).
-
segunda-feira, 28 de maio de 2007 13:27
what role do you belong to?. pls check
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/6fdecefb-7bd3-4203-a58c-36d46ee628bf.htm
-
terça-feira, 29 de maio de 2007 11:37db_owner
-
terça-feira, 29 de maio de 2007 16:25
Hi olof,
can you please go through the steps outlined in section 4.8.1 in http://support.microsoft.com/?id=910228
As per the section in the article, looks like you might have to install the diagram support.
To create database diagrams, change the database compatibility level to 2005, install database diagram support, and then return the database to the desired database compatibility level.
MVPs, please correct me if I am missing something.
Thanks
Meher
-
terça-feira, 29 de maio de 2007 16:35
one other thing I forgot to mention is that the installation of support objects can fail if the database
has been attached or restored from another instance of SQL Server. In such a case there is a
possibility that the database owner name stored in the database may not be a valid logon for the
instance of the SQL Server on to which the database is restored to (or attached to).
I would suggest if thats the case then you can use the Alter statement to change the owner to a valid logon.
ALTER AUTHORIZATION ON DATABASE::your dbname TO yourdesiredlogin
(please see BOL for more details on ALTER AUTHORIZATION).
I would suggest doing through T-SQL than UI and see if it solves your issue.
Thanks
Meher
-
segunda-feira, 1 de outubro de 2007 23:24
Using T-sql instead of ui did the trick for me.
thanks Meher
-
sexta-feira, 5 de setembro de 2008 16:11
Just wanted to add that I was able to connect and install the diagram support objects by using Visual Studio rather than SQL Server Management Studio -- without having to do the ALTER AUTHORIZATION statement. Steps below:
-
Opened Visual Studio 2005
-
Added the Server and database to the Data Connections on the Server Explorer tab.
-
Click Database Diagrams to expand
-
Received message box: This server does not have one or more of the databse objects required to use database diagramming. Do you wish to create them? Clicked YES
-
Diagrams showed up - Yay!
- Sugerido como Resposta oliverkiss.com terça-feira, 2 de fevereiro de 2010 19:53
-
-
sexta-feira, 3 de outubro de 2008 14:05
The same bug also exists in SQL 2008 in it's unchanged form.
-
sábado, 22 de novembro de 2008 18:18 Hi,
The real problem is that the default owner(dbo) doesn't have a login mapped to it at all.As I tried to map the sa login to the database owner I received another error stating "User,group, or role 'dbo' already exists...".However if you try this code it will actually works :
EXEC sp_dbcmptlevel 'yourDB', '90';
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go
use [yourDB]
go
EXECUTE AS USER = N'dbo' REVERT
go- Sugerido como Resposta Maxidag segunda-feira, 20 de julho de 2009 07:52
- Marcado como Resposta Jonathan KehayiasMVP, Moderator quinta-feira, 17 de setembro de 2009 14:24
-
segunda-feira, 1 de dezembro de 2008 09:04
Thanks for this post.
This has saved me a lot of time and worked first time.
-
terça-feira, 24 de março de 2009 07:55I ran the query and the following was returned:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database.
Msg 15517, Level 16, State 1, Line 1
Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
sandeep -
quarta-feira, 15 de abril de 2009 18:56I tried this technique using Visual Studio 2008 Team System Developer Edition SP1 and SQL Server 2008 Developer Edition SP1 and got an error:
The message box that pops up after attempting to expand the Database Diagrams node of the tree says:
This database does not have a valid dob user or you do not have permissions to impersonate the dbo user, so database
diagramming is not available. Do you want to make yourself the dbo of this database in order to use database diagramming?
(Yes)/(No)/(Help)
After clicking Yes to the first message, you get a second message:
This server does not have one of more of the database objects required to use database diagramming. Do you wish to create them?
(Yes)/(No)/(Help)
When I click on the Yes button, the following error message pops up:
Could not obtain information about Windows NT group/user '<mydomain>/<myuserid>', error code 0x5.
What a pity this is still a problem in SQL Server 2008 after all these many months for Microsoft to fix it. :-(
Fred Morrison- Sugerido como Resposta sraveendran3 quinta-feira, 21 de maio de 2009 18:42
- Não Sugerido como Resposta Jonathan KehayiasMVP, Moderator quinta-feira, 17 de setembro de 2009 14:24
-
quinta-feira, 21 de maio de 2009 21:05If the issue is to only the diagram then copy the table script and create a test database. execute the script in the test database
and create the diagram.This worked for me. -
segunda-feira, 20 de julho de 2009 07:53
Hi,
The real problem is that the default owner(dbo) doesn't have a login mapped to it at all.As I tried to map the sa login to the database owner I received another error stating "User,group, or role 'dbo' already exists...".However if you try this code it will actually works :
EXEC sp_dbcmptlevel 'yourDB', '90';
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go
use [yourDB]
go
EXECUTE AS USER = N'dbo' REVERT
go
This work wery well!!
thx
Maxidag- Sugerido como Resposta Nazish Ali Rizvi quarta-feira, 4 de novembro de 2009 09:27
-
quinta-feira, 21 de janeiro de 2010 22:24
It worked in sql server 2008, after setting "sa" as Owner.
Right click database in management studio then click properties.
select "files" page
then set owner as "sa"- Sugerido como Resposta Jerome2606 quarta-feira, 11 de janeiro de 2012 11:46
-
quinta-feira, 4 de fevereiro de 2010 21:06thankssssss sooooooooooo muchhhhhhhhhhhhh
-
domingo, 4 de abril de 2010 22:44Thanks.... It worked like a charm !!...
-
terça-feira, 29 de junho de 2010 13:43Worked brilliantly thanks
-
quarta-feira, 30 de junho de 2010 04:33
This worked for me!
But it doesn't autogenerate the ERDs?
Alagu
-
quarta-feira, 11 de agosto de 2010 01:14
I encountered this problem as well and setting the owner to "sa" is perfect.
Thank you so much!
-
segunda-feira, 30 de agosto de 2010 20:39
Ir worked for me... Thankyou very much
-
quarta-feira, 1 de setembro de 2010 17:26
Thank you - that worked perfectly.
Gary.
-
segunda-feira, 6 de dezembro de 2010 17:16As simple as changing it to sa worked as a charm. Thanks.
-
quinta-feira, 13 de janeiro de 2011 12:30Thanks alot! - this worked for me !
-
quarta-feira, 2 de fevereiro de 2011 13:36
exelente 100% esta es la mejor respuesta
-
Opened Visual Studio 2005
-
Added the Server and database to the Data Connections on the Server Explorer tab.
-
Click Database Diagrams to expand
-
Received message box: This server does not have one or more of the databse objects required to use database diagramming. Do you wish to create them? Clicked YES
-
Diagrams showed up - Yay!
-
-
domingo, 29 de maio de 2011 12:37Thanks Corvin, It works for me
Live -
terça-feira, 20 de dezembro de 2011 21:01
It worked in sql server 2008, after setting "sa" as Owner.
Right click database in management studio then click properties.
select "files" page
then set owner as "sa"
Of all the solutions here - and I tried them all - this was the only one that worked.Thanks!
Was trying on a local install of 2008 R2, on a database I had created a little while earlier.
-
quarta-feira, 18 de abril de 2012 10:35
I had the same problem as you mentioned and I was able to do the following steps to solve the owner issue in MS SQL Management Studio.
Please make sure that you don't select a user name (in step 4 in the figure) that is already Admin for the selected database.Steps:
1. Right-Click on [Database name] -> Properties.
2. Database Properties - [db name] -> Files ->click on [...] button in front of owner.
3. Select Database Owner -> [Browse...]
4. Browse for Objects -> Select one non-admin username5. Hit OK buttons in all windows.
Its all done.- Editado Khalid Mehmood Chitrali quarta-feira, 18 de abril de 2012 10:39 writing steps for SQL MS
- Sugerido como Resposta Khalid Mehmood Chitrali quarta-feira, 18 de abril de 2012 10:39
-
quinta-feira, 3 de maio de 2012 07:46Thankz workz fine..............::::::::::::::::
-
segunda-feira, 11 de junho de 2012 06:55Thanks very much!!!!!!!!!!!!
-
sábado, 25 de agosto de 2012 16:18Thank you Khalid Mehmood Chitrali very much!
-
segunda-feira, 17 de setembro de 2012 04:10thanks janajey it works grate !!!!!!!!
.png)
