Uri Dimant
3/28/2007 6:05:00 AM
Johan
Personally I have not played with this option too much, however I'd suggest
you upgrade to SQL Server 2005 by using BACKUP/RESTORE commads, have you
tried it?
"Johan Garst" <Johangarst343@yahoo.com> wrote in message
news:B_CdnUbA_s_BJpTbnZ2dnUVZ_qWvnZ2d@comcast.com...
> Hi,
>
> I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy
> Database option from Management menu. I want to transfer all tables, and
> all
> stored procedures. I've tried everything for the past 3 days, and it
> didn't
> work. I always get the same error.
>
> Below is the error that I am getting. Can someone please show/tell me a
> simple permission configuration on both servers that would actually work
> when I try to do the Copy Database. This would restore my attitude towards
> migrating to SQL Server 2005. I don't want to have to write any scripts or
> programs for that either.
>
> I've searched all over the internet for a similar problems answered, but
> couldn't find anything useful. Can you please help, because I am ready to
> toss that SQL Server 2005 into a dumpster, and stay with SQL Server 2000.
> I
> am sure that there are hundreds of users like myself with the same
> problem.
> Can someone please answer it really well once and for all finally? I don't
> want to do any Detach or backup/restore methods, or write scripts (once
> again). I just want to be able to use COPY database option in the
> Management
> menu (while the database is running) to transfer this database from SQL
> server 2000 to 2005, just as I could do it in SQL Server 2000.
>
> Can you make up a simple example to explain it. Just one simple database
> on
> Sql 2000 with the simplest permissions, needs to be transferred to 2005.
>
> If you can actually help me, I will be really happy, and will send you a
> nice box of really good chocolates:)
>
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 3/25/2007
> Time: 5:31:14 PM
> User: CAAA3\sqladmin999
> Computer: CAAA3
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_changedbowner @loginame = N'BAAA2\Administrator', @map =
> false
> " failed with the following error: "Cannot find the principal
> 'BAAA2\Administrator', because it does not exist 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.
>
>
>
>