inter-domain migration

#1

I am trying to tranfer a table from a SQLServer2K DB to a SQLServer2005 DB in
another domain. When using the DTS import/export wizard, servers outside the
local domain aren't recognized. Both domains have trust relationships setup.
If I manually enter the server name the following error is reported:

[DBNET][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

I am using the OLE DB provider for SQL Server with Windows authentication.
This process works fine in the other direction. In other words, the 2005 DTS
wizard can resolve all servers in both domains. I have both named pipes and
tcp/ip enabled along with firewall access to port 1433 on both servers. Any
ideas on what the problem might be would be appreciated.

Thanks

#2

Hello teoramirez,

Perhaps the 2K5 server is set up to not allow remote connections in the Surface
Area Configuration Utility.

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

Quote:

I am trying to tranfer a table from a SQLServer2K DB to a
SQLServer2005 DB in another domain. When using the DTS import/export
wizard, servers outside the local domain aren't recognized. Both
domains have trust relationships setup. If I manually enter the server
name the following error is reported:

[DBNET][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

I am using the OLE DB provider for SQL Server with Windows
authentication. This process works fine in the other direction. In
other words, the 2005 DTS wizard can resolve all servers in both
domains. I have both named pipes and tcp/ip enabled along with
firewall access to port 1433 on both servers. Any ideas on what the
problem might be would be appreciated.

Thanks

#3

The 2K5 server has been configured to accept remote connections using both
named pipes and tcp/ip.

"Allan Mitchell" wrote:

Quote:

Hello teoramirez,

Perhaps the 2K5 server is set up to not allow remote connections in the Surface
Area Configuration Utility.

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

I am trying to tranfer a table from a SQLServer2K DB to a
SQLServer2005 DB in another domain. When using the DTS import/export
wizard, servers outside the local domain aren't recognized. Both
domains have trust relationships setup. If I manually enter the server
name the following error is reported:

[DBNET][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

I am using the OLE DB provider for SQL Server with Windows
authentication. This process works fine in the other direction. In
other words, the 2005 DTS wizard can resolve all servers in both
domains. I have both named pipes and tcp/ip enabled along with
firewall access to port 1433 on both servers. Any ideas on what the
problem might be would be appreciated.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

inter-domain migration

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

inter-domain migration - 04-04-2006 , 09:23 AM

Re: inter-domain migration - 04-04-2006 , 02:13 PM

Re: inter-domain migration - 04-04-2006 , 02:48 PM