Prev: Questions regarding Data center operation
Next: Logical proof of SQL change - HELP please!
From: Pedro Juan on 30 Jul 2010 04:39
it is normal that after making the restoration of a database sql server 2000
to sql server 2005 the user does not let me change any of its properties dbo
user?

"Erland Sommarskog" wrote:

> Nico (Nico(a)discussions.microsoft.com) writes:
> > ok thanks for your help , but i have change compatiblity level to 90.
> > but
> > i try changed the propierties of user dbo said me :
> >
> > Exception , error 15405.
> >
> > dont let me change anything in the database sql server 2005.
>
> If you restored the database from another server, dbo may not map to a login
> on the new server. Use
>
> ALTER AUTHORIZATION ON DATABASE::db TO newowner
>
> to fix this.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
> .
>
From: Erland Sommarskog on 30 Jul 2010 05:08
Pedro Juan (PedroJuan(a)discussions.microsoft.com) writes:
> it is normal that after making the restoration of a database sql server
> 2000 to sql server 2005 the user does not let me change any of its
> properties dbo user?

This has nothing to do with migration per se, but this is something that can
happen when you restore a database from server on an other, and the database
owner is not present on the target server.

Note that if the database owner is an SQL Login - other than sa - the owner
is highly unlikely to be present on the target server. There may be a login
with the same name, but mapping is on SID, not on name.



--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Pedro Juan on 30 Jul 2010 06:25
ok, then the user dbo can be modified? or is a user or reserved by sql server?

"Erland Sommarskog" wrote:

> Pedro Juan (PedroJuan(a)discussions.microsoft.com) writes:
> > it is normal that after making the restoration of a database sql server
> > 2000 to sql server 2005 the user does not let me change any of its
> > properties dbo user?
>
> This has nothing to do with migration per se, but this is something that can
> happen when you restore a database from server on an other, and the database
> owner is not present on the target server.
>
> Note that if the database owner is an SQL Login - other than sa - the owner
> is highly unlikely to be present on the target server. There may be a login
> with the same name, but mapping is on SID, not on name.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
> .
>
From: Erland Sommarskog on 30 Jul 2010 07:53
Pedro Juan (PedroJuan(a)discussions.microsoft.com) writes:
> ok, then the user dbo can be modified? or is a user or reserved by sql
> server?

You can change the database owner with

ALTER AUTHORIZATION newowner ON DATABASE::db


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Pedro Juan on 2 Aug 2010 07:16

but when you try to launch the ALTER AUTHORIZATION ON DATABASE:: dbo TO
database tells me that I have no permissions.


"Erland Sommarskog" wrote:

> Pedro Juan (PedroJuan(a)discussions.microsoft.com) writes:
> > ok, then the user dbo can be modified? or is a user or reserved by sql
> > server?
>
> You can change the database owner with
>
> ALTER AUTHORIZATION newowner ON DATABASE::db
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
> .
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Questions regarding Data center operation
Next: Logical proof of SQL change - HELP please!