Error

I installed SQL 2000 on Windows Server 2003 and am trying
to import data from a SQL 7 installed on an NT 4.0
Server. I get an error that reads: Failed to copy objects
from MS SQL server to MS SQL server. Any thoughts?
Thanks in advance."Rico" <anonymous@.discussions.microsoft.com> wrote in message
news:7bb501c48473$2a7913e0$a401280a@.phx.gbl...
> I installed SQL 2000 on Windows Server 2003 and am trying
> to import data from a SQL 7 installed on an NT 4.0
> Server. I get an error that reads: Failed to copy objects
> from MS SQL server to MS SQL server. Any thoughts?
> Thanks in advance.
Are you using DTS from SQL Server 2000? You may want to try restoring a copy
of the SQL Server 7 database to SQL Server 2000, then migrate the objects
you need.
Steve|||Excuse my ignorance but i don't know what DTS is. I do
not have a copy of the SQL 7 Data. I could probably copy
and paste. Would that do?
>--Original Message--
>"Rico" <anonymous@.discussions.microsoft.com> wrote in
message
>news:7bb501c48473$2a7913e0$a401280a@.phx.gbl...
trying[vbcol=seagreen]
objects[vbcol=seagreen]
>Are you using DTS from SQL Server 2000? You may want to
try restoring a copy
>of the SQL Server 7 database to SQL Server 2000, then
migrate the objects
>you need.
>Steve
>
>.
>|||DTS is Data Transformation Services, which is what is used for the database
copy wizard.
You mention that you have SQL Server 7 installed on NT 4, and a copy of SQL
Server 2000 installed on Server 2003.
Have you tried running the import from your copy of SQL Server 2000?
If so, how are you doing it and what errors are you getting?
Steve
"Rico" <anonymous@.discussions.microsoft.com> wrote in message
news:09a001c4848d$48552010$a301280a@.phx.gbl...[vbcol=seagreen]
> Excuse my ignorance but i don't know what DTS is. I do
> not have a copy of the SQL 7 Data. I could probably copy
> and paste. Would that do?
> message
> trying
> objects
> try restoring a copy
> migrate the objects|||I have tried from SQL 2000. From Enterprise manager I
right click SQL server, choose all task, import data and
the DTS Import/Export box comes up. I follow the
prompts. If I use windows authentication, I get a
logging failed for user administrator which I don't
understand because I know I have connectivity. If I try
with SQL authentication (sa) I connect okay and it starts
copying but then about 3 minutes later it stops with
a "Failed to copy objects from MS SQL server to MS SQL
server" error. It seems to copy tables but no data.
>--Original Message--
>DTS is Data Transformation Services, which is what is
used for the database
>copy wizard.
>You mention that you have SQL Server 7 installed on NT
4, and a copy of SQL
>Server 2000 installed on Server 2003.
>Have you tried running the import from your copy of SQL
Server 2000?
>If so, how are you doing it and what errors are you
getting?
>Steve
>"Rico" <anonymous@.discussions.microsoft.com> wrote in
message
>news:09a001c4848d$48552010$a301280a@.phx.gbl...
copy[vbcol=seagreen]
to[vbcol=seagreen]
>
>.
>|||How about the approach I mentioned in my first post to you?
Restore your SQL Server 7.0 database to SQL Server 2000 (use a different
name if necessary).
Then use the import data task wizard you've been using... that should
eliminate any permissions issues.
Steve
"Rico" <anonymous@.discussions.microsoft.com> wrote in message
news:926e01c48606$04986b00$a401280a@.phx.gbl...[vbcol=seagreen]
> I have tried from SQL 2000. From Enterprise manager I
> right click SQL server, choose all task, import data and
> the DTS Import/Export box comes up. I follow the
> prompts. If I use windows authentication, I get a
> logging failed for user administrator which I don't
> understand because I know I have connectivity. If I try
> with SQL authentication (sa) I connect okay and it starts
> copying but then about 3 minutes later it stops with
> a "Failed to copy objects from MS SQL server to MS SQL
> server" error. It seems to copy tables but no data.
> used for the database
> 4, and a copy of SQL
> Server 2000?
> getting?
> message
> copy
> to