migrate DTS from sql2000 to sql 2005 -- sql server dts

mecn
3/31/2006 10:50:02 AM

Hi,

I am trying to migrate DTS package from sql2000sp4 to sql2005/legacy.
I got this error, an error has occurred while establishing a connection to
the server. whne connecting to sql server 2005, this failure may be caused
by the fact that under the default settings sql server does not allow remote
connections.(provider: named pipes provider, error: 40 --could not open a
connection to sql server)....

Any ideas?
Thanks,

Enric
4/3/2006 5:37:04 AM

How many dts you have? If you don't have a lof maybe it'll be a good idea
think how do them again bearing on mind the sql25k features and philosophies
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)

[quoted text, click to view]

Allan Mitchell
4/3/2006 2:00:59 PM

Hello mecn,

Are you trying to connect in your DTS package to a 2K5 server or have you
upgraded the package and it connects to a 2K5 instance? There is a setting
in the SQL Server 2005 Surface Area Configuration utility that tells a 2K5
instance whather or not to accept remote connections.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : migrate DTS from sql2000 to sql 2005