How to force listening on a tcp/ip adress?

[Steve Thompson]

I'm not sure I understand your question, need a little more information...
how is the remote connection made, what kind of remote connection? Have you
defined a TCP/IP port other than 1433?

Steve
"Javier Santos" <jss...@asmred.com> wrote in message
news:4f6e01c1ffd3$784d03a0$b1e62ecf@tkmsftngxa04...
> I've got a sql2k server in a machine with a network card
> and a remote connection.
>
> When I start the service it begins to listen on the
> adresses actually conected. I mean, allways listen on the
> network card but only listen on the remote connection if
> it is connected.
>
> I want to force the sql to listen on the remote connection
> address althougt it is not established at the moment sql
> starts.
>
> Is it possible?
> How?
>
> If not... Any work around?

[Ashwin Kowtha [MS]]

I am afraid this is not possible. SQL listens on all IP's available on the
machine SQL is installed on. It is not possible to configure SQL to listen
on a specific IP address which is not even active. (By active, I mean that
the IP gets assigned only when you remote dial in).

I dont think any workarounds are available.

HTH

Ashwin Kowtha [MS]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
--------------------
|>>>Content-Class: urn:content-classes:message
|>>>From: "Javier Santos" <jss...@asmred.com>
|>>>Sender: "Javier Santos" <jss...@asmred.com>
|>>>Subject: How to force listening on a tcp/ip adress?
|>>>Date: Mon, 20 May 2002 00:53:46 -0700
|>>>Lines: 18
|>>>Message-ID: <4f6e01c1ffd3$784d03a0$b1e62ecf@tkmsftngxa04>
|>>>MIME-Version: 1.0
|>>>Content-Type: text/plain;
|>>> charset="iso-8859-1"
|>>>Content-Transfer-Encoding: 7bit
|>>>X-Newsreader: Microsoft CDO for Windows 2000
|>>>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
|>>>Thread-Index: AcH/03hKgAT8SrZFSc69QCrQAujUfw==
|>>>Newsgroups: microsoft.public.sqlserver.connect
|>>>Path: cpmsftngxa07
|>>>Xref: cpmsftngxa07 microsoft.public.sqlserver.connect:29247
|>>>NNTP-Posting-Host: TKMSFTNGXA04 10.201.232.163
|>>>X-Tomcat-NG: microsoft.public.sqlserver.connect
|>>>
|>>>Hi

[Javier Santos]

Hi Steve

The configuration is like this:
One ethernet Card: 10.0.0.10 (LAN)
One ISDN Card: 10.36.0.15 (by rras) (WAN)

When the system starts up, The ISDN try to connect. At the
same time the sql server starts up.

If the ISDN connects before sql server is up, it listen to
10.0.0.10 and 10.36.0.15, but if the ISDN can't connect
(any reason) it only listen to 10.0.0.10.

When finally the ISDN connects, I can't access SQL SERVER
on 10.36.0.15 (only restarting the sql service)

Is it possible to force sql server to listen on 10.36.0.15
althougt it is not connected at the time the service
starts?

Or maybe force sql server to listen on 0.0.0.0 or
something like this?

BTW: the port is 1433

Thank you very much for your time (and apologizes for my
poor english)

>.
>

[Steve Thompson]

Hi Javier,

I agree with the post from Ashwin Kowtha (MSFT) -- there is no way to force
it to listen on an IP address that is not yet available.

Perhaps you could script or write a batch file -- starting (or cycling) the
MSSqlserver service to start after the ISDN connection is complete.

Steve

"Javier Santos" <jss...@asmred.com> wrote in message

news:51c801c20022$d1e0bd90$9ae62ecf@tkmsftngxa02...

[Javier Santos]

Thanks.

>.
>

[Javier Santos]

Thanks

>.
>

[Neil Pike]

Javier - you can't. Use a firewall, or, on a Win2K box, you can use the
advanced tcp-ip properties on one of the nics to block traffic.

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq