Restore V2 into V3

[hooutoo]

Has anybody been able to restore a v2 (bcm 2003) into v3 (bcm 2007)? I
continue to get error;

"Cannot restore this database because you were not authorized to
backup or restore this databases when this one was originally backed
up. For more information, please contact the database owner of the
systems administrator for more information. Your local database was
not changed."

I've tried a restore in both xp and vista b2 and get the same error
message so it must be either an error in bcm 2007 or some trick to get
authorized that I'm not aware of. Could this be some sort of sql error?

Thanks in advance
Steve

 

[Leonid S. Knyshov]

Has anybody been able to restore a v2 (bcm 2003) into v3 (bcm 2007)? I
continue to get error;

"Cannot restore this database because you were not authorized to
backup or restore this databases when this one was originally backed
up. For more information, please contact the database owner of the
systems administrator for more information. Your local database was
not changed."

I've tried a restore in both xp and vista b2 and get the same error
message so it must be either an error in bcm 2007 or some trick to get
authorized that I'm not aware of. Could this be some sort of sql error?

Thanks in advance
Steve

I tried restoring a database like that before when I imported my production
BCM data into my BCM 2007 and it worked fine for me.

This is a curious message.
--
Leonid S. Knyshov, CEO
Crashproof Solutions, LLC - http://www.crashproofsolutions.com
MCP Exchange 2003/Small Business Server 2003
Microsoft Small Business Specialist Partner
See the tips and tricks section on my website for video tutorials on BCM

 

[Luther]

I've run into this on Vista.

My solution was to give the sqlserver.exe "user", the well known (to
NT) user NetworkServices, permission to use the folder with the
database file.

 

[hooutoo]

Hey Luther

I found the sqlserver.exe with the user id "networkservices" under the
task manager but don't understand how you've given permission to
sqlserver.exe. I've tried moving the backed up db to a new directory
and then given full control to the users "everyone" and
"nerworkservices" but still get the same error message as before.
Please explain in a little more detail what you did and I'll try to
duplicate it. Barring that I still have a working copy of the db on
another machine runnning bcm 2003 so perhaps you have another
suggestion.

Steve

 

[Luther]

I gave NETWORK SERVICE permission to
"c:\users\luther\AppData\Local\Microsoft\Business Contact Manager\" by
right-clicking on the folder, then Properties|Security and gave it Full
control.

Also make sure that folder is not compressed. Sql server doesn't like
that in some circumstances.