dbTalk Databases Forums  

Can't find the source server

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


Discuss Can't find the source server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mar
 
Posts: n/a

Default Can't find the source server - 08-21-2003 , 03:47 PM






i couldn't find the source SQL Server in the same domain.

Reply With Quote
  #2  
Old   
mar
 
Posts: n/a

Default Re: Can't find the source server - 08-21-2003 , 04:39 PM






yes it is a problem. From the old server, I could see all
instances of SQL server in the domain. However, in this
new Sql box, I could only see a handful of instances
excluding the old sql box where i'm pulling data from.

Quote:
-----Original Message-----
In article <032d01c36825$61f65c80$a501280a (AT) phx (DOT) gbl>, mar
mar10c (AT) cox (DOT) net> writes
i couldn't find the source SQL Server in the same
domain.

....and is this a problem?

I use DTS to transform data between servers in different
domains.

What is the question?

What are you trying to do?

What is the full error message you are getting?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com


.


Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Can't find the source server - 08-22-2003 , 01:47 AM



When you say "see" do you mean in the dropdown or do you mean even after you
type the name?

I sometimes find it helpful to register an alias in cliconfig using the IP
address.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Reply With Quote
  #4  
Old   
rwiethorn
 
Posts: n/a

Default Re: Can't find the source server - 08-22-2003 , 07:22 AM



Have you registered the other servers in your Enterprise Manager?

-Rwiethorn


"mar" <mar10c (AT) cox (DOT) net> wrote

Quote:
yes it is a problem. From the old server, I could see all
instances of SQL server in the domain. However, in this
new Sql box, I could only see a handful of instances
excluding the old sql box where i'm pulling data from.

-----Original Message-----
In article <032d01c36825$61f65c80$a501280a (AT) phx (DOT) gbl>, mar
mar10c (AT) cox (DOT) net> writes
i couldn't find the source SQL Server in the same
domain.

....and is this a problem?

I use DTS to transform data between servers in different
domains.

What is the question?

What are you trying to do?

What is the full error message you are getting?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com


.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.