Copy Database Wizard

I am receiving the following error when attempting to copy a SQL Server 2000
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' 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}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Transf
erDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:

> I am receiving the following error when attempting to copy a SQL Server 20
00
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you d
o
> 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}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Tran
sferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>