Re: Opening a TCP/ IP Port or Port Listener

From: Kevin (ReplyTo_at_Newsgroups.only)
Date: 07/30/03 

Date: Wed, 30 Jul 2003 12:30:44 -0700

Yes,

INF: How to Set Up SQL Server 2000 to Listen on Multiple Static TCP Ports

http://support.microsoft.com/default.aspx?scid=kb;en-us;294453 

--
----------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
"Steve Smith" <ssmithmail@yahoo.com> wrote in message
news:049801c356c5$c56f2f10$a101280a@phx.gbl...
> In Network Utility I can enter only one port number.
> But I want to use one port for normal applications and
> another port for internet applications.
>
> Is it possible to add (listen) two ports in SQL Server.
>
> >-----Original Message-----
> >Go to server network utility and specify the new tcp
> port there (you have to
> >restart the sql server service for this change to take
> effect). You can
> >verify that it's working connecting from query analyzer
> and specifying
> >instead of just the servername, the servername a comma
> and then the port.
> >For example:
> >servername,1888
> >
> >--
> >Carlos E. Rojas
> >SQL Server MVP
> >Co-Author SQL Server 2000 Programming by Example
> >
> >
> >"Steve Smith" <ssmithmail@yahoo.com> wrote in message
> >news:0b2801c356a2$422ad5a0$a601280a@phx.gbl...
> >> We are planning to give access from Web Server to SQL
> >> Server through a different port other than 1433.
> >> It is giving an error.
> >>
> >> On SQL Server side, is there anything that we have to
> do
> >> to listen to the new port.
> >>
> >> Thanks
> >>
> >> Steve
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ...
    (Securiteam)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing sql server
    ... port, select All ports, in Remote port, select Fixed port and input 1433 ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
    (microsoft.public.windows.server.sbs)
  • Re: Bug with instanceName property?
    ... If you specify a portnumber attempt to connect using port number. ... I installed SQL Server 2005 on a ... > you get a more efficient connection since it doesn't need to connect to ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)