Copy Database From SQL2000 to SQL2005

Discussion in 'microsoft.public.sqlserver.dts' started by SNORBERG, May 13, 2006.

  1. SNORBERG

    SNORBERG Guest

    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.
     
    SNORBERG, May 13, 2006
    #1
    1. Advertisements

  2. Hello SNORBERG,

    The error to me looks as though the destination server is trying to apply
    a login about which it has no idea. I would say that you have established
    the connection between source and destination successfully.

    BTW. Are you transferring the whole shebang? If you are then I would probably
    do this using BACKUP and RESTORE.


    Allan
     
    Allan Mitchell, May 15, 2006
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.