Monday, March 12, 2012

problem with restore

hi,
i am trying to resore a database on sql --the back up of
which was taken in sql 2000
and i am getting the following error
[SQL-DMO] must be a part of sa, sysadmin or.......group
to complete this operation
i have given the server nt authentication and i am logged
in to the account with sys admin privalges ...
i am running a service pack 4 alredy
can someone help me on this one
You need to be sa to restore the db and it sounds like the account EM is
registered under for that server is not. Try using QA and the RESTORE
command with a proper login and see what happens.
Andrew J. Kelly SQL MVP
"ggupta" <ggupta@.cs.odu.edu> wrote in message
news:124801c4a331$d22dd300$a501280a@.phx.gbl...
> hi,
> i am trying to resore a database on sql --the back up of
> which was taken in sql 2000
> and i am getting the following error
> [SQL-DMO] must be a part of sa, sysadmin or.......group
> to complete this operation
> i have given the server nt authentication and i am logged
> in to the account with sys admin privalges ...
> i am running a service pack 4 alredy
> can someone help me on this one

No comments:

Post a Comment