October 13, 2008 at 10:07 am
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.
October 15, 2008 at 12:32 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply