Re: SQL 2005 dbo user issue
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: Thu, 3 Nov 2005 18:43:09 -0800
Who does it say is the owner on the files page of the properties dialog?
-- HTH Kalen Delaney, SQL Server MVP www.solidqualitylearning.com "TomT" <email@example.com> wrote in message news:6DDBD0CE-9229-4ED4-B8C8-E9CBA9333115@microsoft.com... > Kalen, > > Thanks for your reply. I tried this, and it did change the db owner to sa, > but I still get the same error when clicking the Database Diagrams folder: > "Database diagram support objects cannot be installed becuase this > database > does not have a valid owner. To continue, first use the Files page of the > Database Properties dialog box or the alter authorization statement to set > the database owner to a valid login, then add the database diagram support > objects." > > "Kalen Delaney" wrote: > >> Hi TomT >> >> Open up a query window, and change the owner using sp_changedbowner: >> >> USE whichever_database >> EXEC sp_changedbowner 'sa' >> >> >> -- >> HTH >> Kalen Delaney, SQL Server MVP >> www.solidqualitylearning.com >> >> >> "TomT" <firstname.lastname@example.org> wrote in message >> news:BAE1A421-F492-4BB6-9AEC-2FA1A4A4A5E5@microsoft.com... >> >I brought into SLQ Server 2005 our existing production data for testing, >> >by >> > attaching the mdf and ldf files. I am doing testing prior to upgrading >> > our >> > existing SQL 2000 servers. >> > >> > The problem is the dbo account that came over appears to be incomplete. >> > I >> > discovered this when I clicked on the Database Diagrams folder, and got >> > a >> > message saying the database does not have a valid owner. I checked, as >> > recommended, the properties for the database, and it does show a valid >> > account as owner (not dbo). >> > >> > However, when checking the properties of the dbo account, I see that >> > there >> > is no Login name associated, like, e.g. the AdventureWorks db which has >> > sa >> > entered. >> > >> > (The dbo account on the SQL 2000 server for that database has my login >> > (which is also a domain admin account) as the Login name. On the SLQ >> > 2005 >> > server, this same account (mine) exists properly.) >> > >> > I am unable to modify the problem dbo account, and I'm guessing this >> > issue >> > is causing the problem I get with the Database Diagrams. Is there >> > anyway >> > to >> > repair this account, I'm concerned there might be other problems I >> > haven't >> > run into yet caused by this problem account. >> > >> > thanks for any assistance and advice, >> > >> > TomT >> > >> >> >> >> >