Re: SQL 2005 dbo user issue

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 11/04/05

  • Next message: TomT: "Re: SQL 2005 dbo user issue"
    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" <tomt@newsgroup.nospam> 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" <tomt@newsgroup.nospam> 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
    >> >
    >>
    >>
    >>
    >>
    > 
    

  • Next message: TomT: "Re: SQL 2005 dbo user issue"