|
Subject:
|
login as 'sa' failure - need to restore BAK
|
|
Posted By:
|
bful
|
Post Date:
|
11/15/2003 1:13:16 PM
|
I have two environments:
1. XP Pro w/ SQL 2000. database restores BAK w/no problem
2. Windows 2000 w/ SQL7. database will not restore due to error:
[SQL-DMO]You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator to perform this operation.
When I try to upgrade the password to sa, it advises me there is no login MYSERVER\Administrator. When clearly there is one shown as User in the User area.
I have been going around in circles. I need some help. Anyone? I know this is basic, and so am I, but I still need the help.
Thanks!!!
Bill Fulbright
bfulbright@2100solutions.com
|
|
Reply By:
|
bful
|
Reply Date:
|
11/15/2003 1:19:38 PM
|
I am not restoring from a backup from the resident database.
I am trying to restore a CLIENTFILE.BAK to my new SQL server environment.
If I restore a db from a local backup, I am having the same problem.
What am I missing here?
Bill Fulbright
bfulbright@2100solutions.com
|
|
Reply By:
|
bful
|
Reply Date:
|
11/16/2003 2:33:06 AM
|
Never mind. I simply exported the same info from the SQL 2000 I have on another server to the machine with SQL 7. Worked in 2 min.
I still don't understand why the restore from the external .BAK was such an issue with the 'sa' login.
Bill Fulbright
bfulbright@2100solutions.com
|
