|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Tuesday, October 21, 2008 10:45 AM
Points: 131,
Visits: 33
|
|
I am trying to do a copy db from SQL Server 2000 to SQL Server 2005, but it fails. I get and error message in the event log stating ShellPackage failed. And I get the following error
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'Richard_Evert', @name_in_db = N'SAUser'
" failed with the following error: "'SAUser' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
The login I entered for the 2000 server and the login I entered for the 2005 server have sysadmin rights. SAUser is the login I used in the SQL 2000 db.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, June 11, 2009 12:16 PM
Points: 197,
Visits: 50
|
|
Are you under a mandate to have to use the DBCopy wizard? If not, why not try the good old tried and true "backup and restore" ?:D
|
|
|
|
