Re: DTS and the Internet
From: dan (dea_at_deamon.com)
Date: 08/24/04
- Next message: Jim Trowbridge: "dtsrun.exe drops dead"
- Previous message: Grillon: "Execute Process Task For Batch Files"
- In reply to: Darren Green: "Re: DTS and the Internet"
- Next in thread: dan: "Re: DTS and the Internet"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 22:50:50 +0100
Thanks again Darren, I appreciate your expertize and effort.
It's good to know it is not a login problem, so I can concentrate on the
network part of the problem.
I know for sure the IP address is OK as I am using it daily for FTP and
Terminal Services from the same computer.
Regarding your other hints, I am going to continue my tests tomorrow.
Perhaps I will have to look if there is not a Win2003 setting that creates
the problem.
Kind regards,
Dan
"Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
news:5+tJDnIoQ6KBFwLL@sqldts.com...
> In message <ug3AFahiEHA.1344@TK2MSFTNGP11.phx.gbl>, dan <dea@deamon.com>
> writes
> >Thanks again Darren.
> >> If you are that new to DTS then use the Import Export Wizard to create
> >> your DTS packages for you.
> >I did. I get the same message: "Server does not exist or access denied".
I
> >re-examined the remote server settings. The login I am using is System
and
> >Server Administrator and has all the permissions. What else could be
wrong?
> >
>
> This is going to be the same issue as you had when registering the
> server as suggested in the other branch of this thread, so fix one and
> the other should fall into place.
>
> That message says to me that you cannot find the server. If using a name
> then it can mean the name resolution is not available. for example. If
> using an IP address then are you using the correct IP/ Are you using the
> publicly exposed IP of the server, for example there could be a routing
> device in between that uses NAT for example. Firewalls can also block
> the connection, both at a host and also at the port. By default SQL
> server users TCP port 1433. Get confirmation of what port the remote SQL
> Server is using.
>
> Whilst the error says it may be "access denied", it doesn't really mean
> a login failure. if it is one that then you will get an error message
> back fairly quickly as opposed to teh 20-30s it takes for the current
> message. The login failure error will also say something like "Login
> failed for user xxxx...."
>
>
> Start with the IP address of the remote server and a known username (and
> password) for a SQL Server login, such as sa.
>
> Can you get a connection to work?
>
> Things to try-
> Check that TCP/IP is your default network library, open the (SQL
> Programs group) Client Network Utility on your box, and set the Network
> Library order.
>
> Starting talking to the network boys and find out if you have a firewall
> locally, and if so are you allowed o make outbound connections on TCP
> port 1433. Also check for a similar setup at the remote end.
>
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>
- Next message: Jim Trowbridge: "dtsrun.exe drops dead"
- Previous message: Grillon: "Execute Process Task For Batch Files"
- In reply to: Darren Green: "Re: DTS and the Internet"
- Next in thread: dan: "Re: DTS and the Internet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
