> Source server is a stand-a-lone (no directory) W2K advanced server
> running SQL2000, the destination is a 2003 standard edition server,
> again stand-a-lone, running SQL2005/SP1. So I am using SQL security
> for the transfer since local accounts don't seem to work at all.
>
> Looking at the event log, the first error is Package "ShellPackage"
> failed.
>
> The next one is way to cryptic for me
>
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the
> query
> "EXEC dbo.sp_grantdbaccess @loginame = N'SERVER\snorberg', @name_in_db
> =
> N'snorberg'
> " failed with the following error: "Windows NT user or group
> 'SERVER\snorberg' not found. Check the name again.". 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}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer
> ()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.
> TransferDatabasesUsingSMOTransfer()
> Operator: NT AUTHORITY\SYSTEM
> Source Name: SERVER_SERVER4_Transfer Objects Task
> Source ID: {79DEE9CE-AFA7-45C4-8AEB-24DB9C3EB267}
> Execution ID: {8F0EBEB7-667D-4771-A8FF-D4D22C098F4D}
> Start Time: 5/13/2006 9:56:18 AM
> End Time: 5/13/2006 9:56:18 AM
> This seems is indicate a problem with the security settings but I am
> using SQL security to do the transfer.
>