Hi there,
I am very puzzled with the following behaviour. Just wonder if you have
experienced the same and have a fix for it.
I understand that only a database owner (i.e. dbo) can restore a database.
So what I have done is to change the owner by using
use <databasename>
go
sp_changedbowner '<domain>/<username>'
And when I have confirmed that the NT login '<domain>/<username>' is now a
database owner by using
use <databasename>
go
sp_helpusers
However, when the user '<domain>/username>' try to restore the database,
SQL reports the following error:
"Microsoft SQL-DMO (ODBC SQLState:42000)
Only members of the sysadmn role or the database owner of '<databasename>'
can run RESTORE DATABASE. Backup or restore operation terminating
abnormally."
But I am in fact the user is in fact a database owner.
However, if the database owner is set to a SQL standard login, I don't have
the above problem. How can I get rid of the error when an NT login is a
database owner.
Thanks for your help in advance.
ChingTai